{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import lightgbm as lgbm\n",
    "import xgboost\n",
    "from sklearn.model_selection import KFold\n",
    "import warnings\n",
    "import gc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "warnings.filterwarnings(\"ignore\")\n",
    "pd.set_option(\"display.max_columns\", 200)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_csv(\"EDA_Data_01.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([10, 12, 13,  4,  3, 11])"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.EVHVS.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>index</th>\n",
       "      <th>mo</th>\n",
       "      <th>tp</th>\n",
       "      <th>dr</th>\n",
       "      <th>ln</th>\n",
       "      <th>lt</th>\n",
       "      <th>hd</th>\n",
       "      <th>sp</th>\n",
       "      <th>tm</th>\n",
       "      <th>mn</th>\n",
       "      <th>mt</th>\n",
       "      <th>mh</th>\n",
       "      <th>ml</th>\n",
       "      <th>mr</th>\n",
       "      <th>SpeedLimit</th>\n",
       "      <th>hdop</th>\n",
       "      <th>numsat</th>\n",
       "      <th>IMEI</th>\n",
       "      <th>trip_id</th>\n",
       "      <th>EVTmg</th>\n",
       "      <th>EVVer</th>\n",
       "      <th>EVCfg</th>\n",
       "      <th>EVIGS</th>\n",
       "      <th>EVIGC</th>\n",
       "      <th>EVVSP</th>\n",
       "      <th>EVDRG</th>\n",
       "      <th>EVGPO</th>\n",
       "      <th>EVBRP</th>\n",
       "      <th>EVCFN</th>\n",
       "      <th>EVICR</th>\n",
       "      <th>EVTRQ</th>\n",
       "      <th>EVCST</th>\n",
       "      <th>EVDDC</th>\n",
       "      <th>EVBCA</th>\n",
       "      <th>EVBBV</th>\n",
       "      <th>EVDR1</th>\n",
       "      <th>EVDR2</th>\n",
       "      <th>EVRGT</th>\n",
       "      <th>EVACP</th>\n",
       "      <th>EVBAP_Latest</th>\n",
       "      <th>EVBAP_Max</th>\n",
       "      <th>EVBAP_Min</th>\n",
       "      <th>EVCCS</th>\n",
       "      <th>EVCM1</th>\n",
       "      <th>EVCTM</th>\n",
       "      <th>EVCCU</th>\n",
       "      <th>EVCSD</th>\n",
       "      <th>EVVCE</th>\n",
       "      <th>EVPSC_Latest</th>\n",
       "      <th>EVPSC_Max</th>\n",
       "      <th>EVPSC_Min</th>\n",
       "      <th>EVVOU</th>\n",
       "      <th>EVCOU</th>\n",
       "      <th>EVCPV</th>\n",
       "      <th>EVVCD</th>\n",
       "      <th>EVCCD</th>\n",
       "      <th>EVCSC</th>\n",
       "      <th>EVEST</th>\n",
       "      <th>EVCHS</th>\n",
       "      <th>EVR10</th>\n",
       "      <th>EVRMN</th>\n",
       "      <th>EVHVS</th>\n",
       "      <th>EVV12</th>\n",
       "      <th>EVPWA_MAX</th>\n",
       "      <th>EVPWA_MIN</th>\n",
       "      <th>EVMCV_MAX</th>\n",
       "      <th>EVMCV_MIN</th>\n",
       "      <th>EVSMA_MAX</th>\n",
       "      <th>EVSMA_MIN</th>\n",
       "      <th>EVSMI_MAX</th>\n",
       "      <th>EVSMI_MIN</th>\n",
       "      <th>EVSOH</th>\n",
       "      <th>EVBMA_Latest</th>\n",
       "      <th>EVBMA_Max</th>\n",
       "      <th>EVBMA_Min</th>\n",
       "      <th>EVBMI_Latest</th>\n",
       "      <th>EVBMI_Max</th>\n",
       "      <th>EVBMI_Min</th>\n",
       "      <th>EVBOA_AVG</th>\n",
       "      <th>EVBOA_MAX</th>\n",
       "      <th>EVBOA_MIN</th>\n",
       "      <th>EVBOV_AVG</th>\n",
       "      <th>EVBOV_MAX</th>\n",
       "      <th>EVBOV_MIN</th>\n",
       "      <th>EVIRP</th>\n",
       "      <th>EVIRN</th>\n",
       "      <th>EVSOMA</th>\n",
       "      <th>EVSOMI</th>\n",
       "      <th>EVIGM_Latest</th>\n",
       "      <th>EVIGM_Max</th>\n",
       "      <th>EVIGM_Min</th>\n",
       "      <th>EVCOM_Latest</th>\n",
       "      <th>EVCOM_Max</th>\n",
       "      <th>EVCOM_Min</th>\n",
       "      <th>EVICO_Latest</th>\n",
       "      <th>EVICO_Max</th>\n",
       "      <th>EVICO_Min</th>\n",
       "      <th>EVIRT_Latest</th>\n",
       "      <th>EVIRT_Max</th>\n",
       "      <th>EVIRT_Min</th>\n",
       "      <th>EVIDC</th>\n",
       "      <th>EVMGT</th>\n",
       "      <th>EVMGS</th>\n",
       "      <th>EVMGF</th>\n",
       "      <th>EVMGR</th>\n",
       "      <th>EVIND</th>\n",
       "      <th>EVICM</th>\n",
       "      <th>EVCPW</th>\n",
       "      <th>EVCPF_Latest</th>\n",
       "      <th>EVCPF_Max</th>\n",
       "      <th>EVCPF_Min</th>\n",
       "      <th>EVCI1_Latest</th>\n",
       "      <th>EVCI1_Max</th>\n",
       "      <th>EVCI1_Min</th>\n",
       "      <th>EVCI2_Latest</th>\n",
       "      <th>EVCI2_Max</th>\n",
       "      <th>EVCI2_Min</th>\n",
       "      <th>EVCBD_Latest</th>\n",
       "      <th>EVCBD_Max</th>\n",
       "      <th>EVCBD_Min</th>\n",
       "      <th>EVCRP</th>\n",
       "      <th>EVACV_AVG</th>\n",
       "      <th>EVACV_Max</th>\n",
       "      <th>EVACV_Min</th>\n",
       "      <th>EVCDO_AVG</th>\n",
       "      <th>EVCDO_Max</th>\n",
       "      <th>EVCDO_Min</th>\n",
       "      <th>EVCCO_AVG</th>\n",
       "      <th>EVCCO_Max</th>\n",
       "      <th>EVCCO_Min</th>\n",
       "      <th>EVSDT</th>\n",
       "      <th>EVCHC</th>\n",
       "      <th>EVCHT_AVG</th>\n",
       "      <th>EVCHT_Max</th>\n",
       "      <th>EVCHT_Min</th>\n",
       "      <th>EVCHE</th>\n",
       "      <th>EVDI1</th>\n",
       "      <th>EVDI2</th>\n",
       "      <th>EVDIT</th>\n",
       "      <th>EVOII</th>\n",
       "      <th>EVDOA</th>\n",
       "      <th>EVDOV</th>\n",
       "      <th>EVDSE</th>\n",
       "      <th>EVACS</th>\n",
       "      <th>EVPSS</th>\n",
       "      <th>EVMSC</th>\n",
       "      <th>EVRER</th>\n",
       "      <th>EVDRV</th>\n",
       "      <th>EVMTR</th>\n",
       "      <th>EVODO</th>\n",
       "      <th>EVOAS</th>\n",
       "      <th>EVHTR</th>\n",
       "      <th>EVACE</th>\n",
       "      <th>EVTRE</th>\n",
       "      <th>EVCLC</th>\n",
       "      <th>EVBFN</th>\n",
       "      <th>EVIST</th>\n",
       "      <th>EVHTP_AVG</th>\n",
       "      <th>EVHTP_Max</th>\n",
       "      <th>EVHTP_Min</th>\n",
       "      <th>EVVBT</th>\n",
       "      <th>EVGSM</th>\n",
       "      <th>EVACO_X</th>\n",
       "      <th>EVACO_Y</th>\n",
       "      <th>EVACO_Z</th>\n",
       "      <th>Unnamed: 164</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>DEFREG:352891066263282</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>77.072211</td>\n",
       "      <td>28.497356</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1543193200380</td>\n",
       "      <td>77.072211</td>\n",
       "      <td>28.497356</td>\n",
       "      <td>88.0052</td>\n",
       "      <td>1104361843</td>\n",
       "      <td>5</td>\n",
       "      <td>30.0</td>\n",
       "      <td>16.3</td>\n",
       "      <td>3</td>\n",
       "      <td>352891066263282</td>\n",
       "      <td>Trip not started</td>\n",
       "      <td>P</td>\n",
       "      <td>M1_POCEV.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1191</td>\n",
       "      <td>0.0</td>\n",
       "      <td>78</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>13.9</td>\n",
       "      <td>0</td>\n",
       "      <td>58.5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>13.7</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>4.01</td>\n",
       "      <td>4.01</td>\n",
       "      <td>89.8</td>\n",
       "      <td>89.8</td>\n",
       "      <td>89.3</td>\n",
       "      <td>89.3</td>\n",
       "      <td>100</td>\n",
       "      <td>18.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>17.5</td>\n",
       "      <td>17.5</td>\n",
       "      <td>17.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>8.75</td>\n",
       "      <td>5.5</td>\n",
       "      <td>264.5</td>\n",
       "      <td>255.25</td>\n",
       "      <td>255.0</td>\n",
       "      <td>1810.0</td>\n",
       "      <td>1810</td>\n",
       "      <td>100.0</td>\n",
       "      <td>99.9</td>\n",
       "      <td>16</td>\n",
       "      <td>205</td>\n",
       "      <td>58</td>\n",
       "      <td>17</td>\n",
       "      <td>183</td>\n",
       "      <td>-48</td>\n",
       "      <td>67</td>\n",
       "      <td>155</td>\n",
       "      <td>71</td>\n",
       "      <td>17</td>\n",
       "      <td>188</td>\n",
       "      <td>-38</td>\n",
       "      <td>512.0</td>\n",
       "      <td>-0.1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>266</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "      <td>13.8</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>34.75</td>\n",
       "      <td>26.1</td>\n",
       "      <td>0</td>\n",
       "      <td>-65532</td>\n",
       "      <td>0</td>\n",
       "      <td>2217</td>\n",
       "      <td>15.5</td>\n",
       "      <td>1</td>\n",
       "      <td>14.9</td>\n",
       "      <td>4.0</td>\n",
       "      <td>65</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3920</td>\n",
       "      <td>3920</td>\n",
       "      <td>3920</td>\n",
       "      <td>138</td>\n",
       "      <td>0</td>\n",
       "      <td>684.0</td>\n",
       "      <td>-789.0</td>\n",
       "      <td>-135.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>DEFREG:352891066263282</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>77.072211</td>\n",
       "      <td>28.497356</td>\n",
       "      <td>2.0</td>\n",
       "      <td>100</td>\n",
       "      <td>1543193200480</td>\n",
       "      <td>77.072211</td>\n",
       "      <td>28.497356</td>\n",
       "      <td>88.0052</td>\n",
       "      <td>1104361843</td>\n",
       "      <td>5</td>\n",
       "      <td>30.0</td>\n",
       "      <td>16.3</td>\n",
       "      <td>3</td>\n",
       "      <td>352891066263282</td>\n",
       "      <td>Trip not started</td>\n",
       "      <td>P</td>\n",
       "      <td>M1_POCEV.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1191</td>\n",
       "      <td>0.0</td>\n",
       "      <td>78</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>13.9</td>\n",
       "      <td>0</td>\n",
       "      <td>58.5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>13.7</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>4.01</td>\n",
       "      <td>4.01</td>\n",
       "      <td>89.8</td>\n",
       "      <td>89.8</td>\n",
       "      <td>89.3</td>\n",
       "      <td>89.3</td>\n",
       "      <td>100</td>\n",
       "      <td>18.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>17.5</td>\n",
       "      <td>17.5</td>\n",
       "      <td>17.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>8.75</td>\n",
       "      <td>5.5</td>\n",
       "      <td>264.5</td>\n",
       "      <td>255.25</td>\n",
       "      <td>255.0</td>\n",
       "      <td>1810.0</td>\n",
       "      <td>1810</td>\n",
       "      <td>100.0</td>\n",
       "      <td>99.9</td>\n",
       "      <td>16</td>\n",
       "      <td>205</td>\n",
       "      <td>58</td>\n",
       "      <td>17</td>\n",
       "      <td>183</td>\n",
       "      <td>-48</td>\n",
       "      <td>67</td>\n",
       "      <td>155</td>\n",
       "      <td>71</td>\n",
       "      <td>17</td>\n",
       "      <td>188</td>\n",
       "      <td>-38</td>\n",
       "      <td>512.0</td>\n",
       "      <td>-0.1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>266</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "      <td>13.8</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>34.75</td>\n",
       "      <td>26.1</td>\n",
       "      <td>0</td>\n",
       "      <td>-65532</td>\n",
       "      <td>0</td>\n",
       "      <td>2217</td>\n",
       "      <td>15.5</td>\n",
       "      <td>1</td>\n",
       "      <td>14.9</td>\n",
       "      <td>4.0</td>\n",
       "      <td>65</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3920</td>\n",
       "      <td>3920</td>\n",
       "      <td>3920</td>\n",
       "      <td>138</td>\n",
       "      <td>0</td>\n",
       "      <td>684.0</td>\n",
       "      <td>-789.0</td>\n",
       "      <td>-135.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>DEFREG:352891066263282</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>77.072211</td>\n",
       "      <td>28.497356</td>\n",
       "      <td>2.0</td>\n",
       "      <td>200</td>\n",
       "      <td>1543193200580</td>\n",
       "      <td>77.072211</td>\n",
       "      <td>28.497356</td>\n",
       "      <td>88.0052</td>\n",
       "      <td>1104361843</td>\n",
       "      <td>5</td>\n",
       "      <td>30.0</td>\n",
       "      <td>16.3</td>\n",
       "      <td>3</td>\n",
       "      <td>352891066263282</td>\n",
       "      <td>Trip not started</td>\n",
       "      <td>P</td>\n",
       "      <td>M1_POCEV.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1191</td>\n",
       "      <td>0.0</td>\n",
       "      <td>78</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>13.9</td>\n",
       "      <td>0</td>\n",
       "      <td>58.5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>13.7</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>4.01</td>\n",
       "      <td>4.01</td>\n",
       "      <td>89.8</td>\n",
       "      <td>89.8</td>\n",
       "      <td>89.3</td>\n",
       "      <td>89.3</td>\n",
       "      <td>100</td>\n",
       "      <td>18.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>17.5</td>\n",
       "      <td>17.5</td>\n",
       "      <td>17.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>8.75</td>\n",
       "      <td>5.5</td>\n",
       "      <td>264.5</td>\n",
       "      <td>255.25</td>\n",
       "      <td>255.0</td>\n",
       "      <td>1810.0</td>\n",
       "      <td>1810</td>\n",
       "      <td>100.0</td>\n",
       "      <td>99.9</td>\n",
       "      <td>16</td>\n",
       "      <td>205</td>\n",
       "      <td>58</td>\n",
       "      <td>17</td>\n",
       "      <td>183</td>\n",
       "      <td>-48</td>\n",
       "      <td>67</td>\n",
       "      <td>155</td>\n",
       "      <td>71</td>\n",
       "      <td>17</td>\n",
       "      <td>188</td>\n",
       "      <td>-38</td>\n",
       "      <td>512.0</td>\n",
       "      <td>-0.1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>266</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "      <td>13.8</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>34.75</td>\n",
       "      <td>26.1</td>\n",
       "      <td>0</td>\n",
       "      <td>-65532</td>\n",
       "      <td>0</td>\n",
       "      <td>2217</td>\n",
       "      <td>15.5</td>\n",
       "      <td>1</td>\n",
       "      <td>14.9</td>\n",
       "      <td>4.0</td>\n",
       "      <td>65</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3920</td>\n",
       "      <td>3920</td>\n",
       "      <td>3920</td>\n",
       "      <td>138</td>\n",
       "      <td>0</td>\n",
       "      <td>684.0</td>\n",
       "      <td>-789.0</td>\n",
       "      <td>-135.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>DEFREG:352891066263282</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>77.072211</td>\n",
       "      <td>28.497356</td>\n",
       "      <td>2.0</td>\n",
       "      <td>300</td>\n",
       "      <td>1543193200680</td>\n",
       "      <td>77.072211</td>\n",
       "      <td>28.497356</td>\n",
       "      <td>88.0052</td>\n",
       "      <td>1104361843</td>\n",
       "      <td>5</td>\n",
       "      <td>30.0</td>\n",
       "      <td>16.3</td>\n",
       "      <td>3</td>\n",
       "      <td>352891066263282</td>\n",
       "      <td>Trip not started</td>\n",
       "      <td>P</td>\n",
       "      <td>M1_POCEV.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1191</td>\n",
       "      <td>0.0</td>\n",
       "      <td>78</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>13.9</td>\n",
       "      <td>0</td>\n",
       "      <td>58.5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>13.7</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>4.01</td>\n",
       "      <td>4.01</td>\n",
       "      <td>89.8</td>\n",
       "      <td>89.8</td>\n",
       "      <td>89.3</td>\n",
       "      <td>89.3</td>\n",
       "      <td>100</td>\n",
       "      <td>18.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>17.5</td>\n",
       "      <td>17.5</td>\n",
       "      <td>17.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>8.75</td>\n",
       "      <td>5.5</td>\n",
       "      <td>264.5</td>\n",
       "      <td>255.25</td>\n",
       "      <td>255.0</td>\n",
       "      <td>1810.0</td>\n",
       "      <td>1810</td>\n",
       "      <td>100.0</td>\n",
       "      <td>99.9</td>\n",
       "      <td>16</td>\n",
       "      <td>205</td>\n",
       "      <td>58</td>\n",
       "      <td>17</td>\n",
       "      <td>183</td>\n",
       "      <td>-48</td>\n",
       "      <td>67</td>\n",
       "      <td>155</td>\n",
       "      <td>71</td>\n",
       "      <td>17</td>\n",
       "      <td>188</td>\n",
       "      <td>-38</td>\n",
       "      <td>512.0</td>\n",
       "      <td>-0.1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>266</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "      <td>13.8</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>34.75</td>\n",
       "      <td>26.1</td>\n",
       "      <td>0</td>\n",
       "      <td>-65532</td>\n",
       "      <td>0</td>\n",
       "      <td>2217</td>\n",
       "      <td>15.5</td>\n",
       "      <td>1</td>\n",
       "      <td>14.9</td>\n",
       "      <td>4.0</td>\n",
       "      <td>65</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3920</td>\n",
       "      <td>3920</td>\n",
       "      <td>3920</td>\n",
       "      <td>138</td>\n",
       "      <td>0</td>\n",
       "      <td>684.0</td>\n",
       "      <td>-789.0</td>\n",
       "      <td>-135.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>DEFREG:352891066263282</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>77.072211</td>\n",
       "      <td>28.497356</td>\n",
       "      <td>2.0</td>\n",
       "      <td>400</td>\n",
       "      <td>1543193200780</td>\n",
       "      <td>77.072211</td>\n",
       "      <td>28.497356</td>\n",
       "      <td>88.0052</td>\n",
       "      <td>1104361843</td>\n",
       "      <td>5</td>\n",
       "      <td>30.0</td>\n",
       "      <td>16.3</td>\n",
       "      <td>3</td>\n",
       "      <td>352891066263282</td>\n",
       "      <td>Trip not started</td>\n",
       "      <td>P</td>\n",
       "      <td>M1_POCEV.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1191</td>\n",
       "      <td>0.0</td>\n",
       "      <td>78</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>13.9</td>\n",
       "      <td>0</td>\n",
       "      <td>58.5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>13.7</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>4.01</td>\n",
       "      <td>4.01</td>\n",
       "      <td>89.8</td>\n",
       "      <td>89.8</td>\n",
       "      <td>89.3</td>\n",
       "      <td>89.3</td>\n",
       "      <td>100</td>\n",
       "      <td>18.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>17.5</td>\n",
       "      <td>17.5</td>\n",
       "      <td>17.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>8.75</td>\n",
       "      <td>5.5</td>\n",
       "      <td>264.5</td>\n",
       "      <td>255.25</td>\n",
       "      <td>255.0</td>\n",
       "      <td>1810.0</td>\n",
       "      <td>1810</td>\n",
       "      <td>100.0</td>\n",
       "      <td>99.9</td>\n",
       "      <td>16</td>\n",
       "      <td>205</td>\n",
       "      <td>58</td>\n",
       "      <td>17</td>\n",
       "      <td>183</td>\n",
       "      <td>-48</td>\n",
       "      <td>67</td>\n",
       "      <td>155</td>\n",
       "      <td>71</td>\n",
       "      <td>17</td>\n",
       "      <td>188</td>\n",
       "      <td>-38</td>\n",
       "      <td>512.0</td>\n",
       "      <td>-0.1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>266</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "      <td>13.8</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>34.75</td>\n",
       "      <td>26.1</td>\n",
       "      <td>0</td>\n",
       "      <td>-65532</td>\n",
       "      <td>0</td>\n",
       "      <td>2217</td>\n",
       "      <td>15.5</td>\n",
       "      <td>1</td>\n",
       "      <td>14.9</td>\n",
       "      <td>4.0</td>\n",
       "      <td>65</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3920</td>\n",
       "      <td>3920</td>\n",
       "      <td>3920</td>\n",
       "      <td>138</td>\n",
       "      <td>0</td>\n",
       "      <td>684.0</td>\n",
       "      <td>-789.0</td>\n",
       "      <td>-135.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  index                      mo  tp  dr         ln         lt  \\\n",
       "0           0      0  DEFREG:352891066263282   1 NaN  77.072211  28.497356   \n",
       "1           1      1  DEFREG:352891066263282   1 NaN  77.072211  28.497356   \n",
       "2           2      2  DEFREG:352891066263282   1 NaN  77.072211  28.497356   \n",
       "3           3      3  DEFREG:352891066263282   1 NaN  77.072211  28.497356   \n",
       "4           4      4  DEFREG:352891066263282   1 NaN  77.072211  28.497356   \n",
       "\n",
       "    hd   sp             tm         mn         mt       mh          ml  mr  \\\n",
       "0  2.0    0  1543193200380  77.072211  28.497356  88.0052  1104361843   5   \n",
       "1  2.0  100  1543193200480  77.072211  28.497356  88.0052  1104361843   5   \n",
       "2  2.0  200  1543193200580  77.072211  28.497356  88.0052  1104361843   5   \n",
       "3  2.0  300  1543193200680  77.072211  28.497356  88.0052  1104361843   5   \n",
       "4  2.0  400  1543193200780  77.072211  28.497356  88.0052  1104361843   5   \n",
       "\n",
       "   SpeedLimit  hdop  numsat             IMEI           trip_id EVTmg  \\\n",
       "0        30.0  16.3       3  352891066263282  Trip not started     P   \n",
       "1        30.0  16.3       3  352891066263282  Trip not started     P   \n",
       "2        30.0  16.3       3  352891066263282  Trip not started     P   \n",
       "3        30.0  16.3       3  352891066263282  Trip not started     P   \n",
       "4        30.0  16.3       3  352891066263282  Trip not started     P   \n",
       "\n",
       "        EVVer  EVCfg  EVIGS  EVIGC  EVVSP  EVDRG  EVGPO  EVBRP  EVCFN  EVICR  \\\n",
       "0  M1_POCEV.0    NaN      1   1191    0.0     78     10      0      0      1   \n",
       "1  M1_POCEV.0    NaN      1   1191    0.0     78     10      0      0      1   \n",
       "2  M1_POCEV.0    NaN      1   1191    0.0     78     10      0      0      1   \n",
       "3  M1_POCEV.0    NaN      1   1191    0.0     78     10      0      0      1   \n",
       "4  M1_POCEV.0    NaN      1   1191    0.0     78     10      0      0      1   \n",
       "\n",
       "   EVTRQ  EVCST  EVDDC  EVBCA  EVBBV  EVDR1  EVDR2  EVRGT  EVACP  \\\n",
       "0    0.0      1   13.9      0   58.5      0      0      0    0.0   \n",
       "1    0.0      1   13.9      0   58.5      0      0      0    0.0   \n",
       "2    0.0      1   13.9      0   58.5      0      0      0    0.0   \n",
       "3    0.0      1   13.9      0   58.5      0      0      0    0.0   \n",
       "4    0.0      1   13.9      0   58.5      0      0      0    0.0   \n",
       "\n",
       "   EVBAP_Latest  EVBAP_Max  EVBAP_Min  EVCCS  EVCM1  EVCTM  EVCCU  EVCSD  \\\n",
       "0             0          0          0      0    NaN    NaN    NaN    NaN   \n",
       "1             0          0          0      0    NaN    NaN    NaN    NaN   \n",
       "2             0          0          0      0    NaN    NaN    NaN    NaN   \n",
       "3             0          0          0      0    NaN    NaN    NaN    NaN   \n",
       "4             0          0          0      0    NaN    NaN    NaN    NaN   \n",
       "\n",
       "   EVVCE  EVPSC_Latest  EVPSC_Max  EVPSC_Min  EVVOU  EVCOU  EVCPV  EVVCD  \\\n",
       "0    NaN           NaN        NaN        NaN    NaN    NaN    NaN    NaN   \n",
       "1    NaN           NaN        NaN        NaN    NaN    NaN    NaN    NaN   \n",
       "2    NaN           NaN        NaN        NaN    NaN    NaN    NaN    NaN   \n",
       "3    NaN           NaN        NaN        NaN    NaN    NaN    NaN    NaN   \n",
       "4    NaN           NaN        NaN        NaN    NaN    NaN    NaN    NaN   \n",
       "\n",
       "   EVCCD  EVCSC  EVEST  EVCHS  EVR10  EVRMN  EVHVS  EVV12  EVPWA_MAX  \\\n",
       "0    NaN    NaN    NaN    NaN    NaN    NaN     10   13.7       0.25   \n",
       "1    NaN    NaN    NaN    NaN    NaN    NaN     10   13.7       0.25   \n",
       "2    NaN    NaN    NaN    NaN    NaN    NaN     10   13.7       0.25   \n",
       "3    NaN    NaN    NaN    NaN    NaN    NaN     10   13.7       0.25   \n",
       "4    NaN    NaN    NaN    NaN    NaN    NaN     10   13.7       0.25   \n",
       "\n",
       "   EVPWA_MIN  EVMCV_MAX  EVMCV_MIN  EVSMA_MAX  EVSMA_MIN  EVSMI_MAX  \\\n",
       "0       0.25       4.01       4.01       89.8       89.8       89.3   \n",
       "1       0.25       4.01       4.01       89.8       89.8       89.3   \n",
       "2       0.25       4.01       4.01       89.8       89.8       89.3   \n",
       "3       0.25       4.01       4.01       89.8       89.8       89.3   \n",
       "4       0.25       4.01       4.01       89.8       89.8       89.3   \n",
       "\n",
       "   EVSMI_MIN  EVSOH  EVBMA_Latest  EVBMA_Max  EVBMA_Min  EVBMI_Latest  \\\n",
       "0       89.3    100          18.0       18.0       18.0          17.5   \n",
       "1       89.3    100          18.0       18.0       18.0          17.5   \n",
       "2       89.3    100          18.0       18.0       18.0          17.5   \n",
       "3       89.3    100          18.0       18.0       18.0          17.5   \n",
       "4       89.3    100          18.0       18.0       18.0          17.5   \n",
       "\n",
       "   EVBMI_Max  EVBMI_Min  EVBOA_AVG  EVBOA_MAX  EVBOA_MIN  EVBOV_AVG  \\\n",
       "0       17.5       17.5        0.5       8.75        5.5      264.5   \n",
       "1       17.5       17.5        0.5       8.75        5.5      264.5   \n",
       "2       17.5       17.5        0.5       8.75        5.5      264.5   \n",
       "3       17.5       17.5        0.5       8.75        5.5      264.5   \n",
       "4       17.5       17.5        0.5       8.75        5.5      264.5   \n",
       "\n",
       "   EVBOV_MAX  EVBOV_MIN   EVIRP  EVIRN  EVSOMA  EVSOMI  EVIGM_Latest  \\\n",
       "0     255.25      255.0  1810.0   1810   100.0    99.9            16   \n",
       "1     255.25      255.0  1810.0   1810   100.0    99.9            16   \n",
       "2     255.25      255.0  1810.0   1810   100.0    99.9            16   \n",
       "3     255.25      255.0  1810.0   1810   100.0    99.9            16   \n",
       "4     255.25      255.0  1810.0   1810   100.0    99.9            16   \n",
       "\n",
       "   EVIGM_Max  EVIGM_Min  EVCOM_Latest  EVCOM_Max  EVCOM_Min  EVICO_Latest  \\\n",
       "0        205         58            17        183        -48            67   \n",
       "1        205         58            17        183        -48            67   \n",
       "2        205         58            17        183        -48            67   \n",
       "3        205         58            17        183        -48            67   \n",
       "4        205         58            17        183        -48            67   \n",
       "\n",
       "   EVICO_Max  EVICO_Min  EVIRT_Latest  EVIRT_Max  EVIRT_Min  EVIDC  EVMGT  \\\n",
       "0        155         71            17        188        -38  512.0   -0.1   \n",
       "1        155         71            17        188        -38  512.0   -0.1   \n",
       "2        155         71            17        188        -38  512.0   -0.1   \n",
       "3        155         71            17        188        -38  512.0   -0.1   \n",
       "4        155         71            17        188        -38  512.0   -0.1   \n",
       "\n",
       "   EVMGS  EVMGF  EVMGR  EVIND  EVICM  EVCPW  EVCPF_Latest  EVCPF_Max  \\\n",
       "0      0    0.0    0.0    266      3    NaN           NaN        NaN   \n",
       "1      0    0.0    0.0    266      3    NaN           NaN        NaN   \n",
       "2      0    0.0    0.0    266      3    NaN           NaN        NaN   \n",
       "3      0    0.0    0.0    266      3    NaN           NaN        NaN   \n",
       "4      0    0.0    0.0    266      3    NaN           NaN        NaN   \n",
       "\n",
       "   EVCPF_Min  EVCI1_Latest  EVCI1_Max  EVCI1_Min  EVCI2_Latest  EVCI2_Max  \\\n",
       "0        NaN           NaN        NaN        NaN           NaN        NaN   \n",
       "1        NaN           NaN        NaN        NaN           NaN        NaN   \n",
       "2        NaN           NaN        NaN        NaN           NaN        NaN   \n",
       "3        NaN           NaN        NaN        NaN           NaN        NaN   \n",
       "4        NaN           NaN        NaN        NaN           NaN        NaN   \n",
       "\n",
       "   EVCI2_Min  EVCBD_Latest  EVCBD_Max  EVCBD_Min  EVCRP  EVACV_AVG  EVACV_Max  \\\n",
       "0        NaN           NaN        NaN        NaN      1        NaN        NaN   \n",
       "1        NaN           NaN        NaN        NaN      1        NaN        NaN   \n",
       "2        NaN           NaN        NaN        NaN      1        NaN        NaN   \n",
       "3        NaN           NaN        NaN        NaN      1        NaN        NaN   \n",
       "4        NaN           NaN        NaN        NaN      1        NaN        NaN   \n",
       "\n",
       "   EVACV_Min  EVCDO_AVG  EVCDO_Max  EVCDO_Min  EVCCO_AVG  EVCCO_Max  \\\n",
       "0        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "1        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "2        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "3        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "4        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "\n",
       "   EVCCO_Min  EVSDT  EVCHC  EVCHT_AVG  EVCHT_Max  EVCHT_Min  EVCHE  EVDI1  \\\n",
       "0        NaN    NaN    NaN        NaN        NaN        NaN    NaN     17   \n",
       "1        NaN    NaN    NaN        NaN        NaN        NaN    NaN     17   \n",
       "2        NaN    NaN    NaN        NaN        NaN        NaN    NaN     17   \n",
       "3        NaN    NaN    NaN        NaN        NaN        NaN    NaN     17   \n",
       "4        NaN    NaN    NaN        NaN        NaN        NaN    NaN     17   \n",
       "\n",
       "   EVDI2  EVDIT  EVOII  EVDOA  EVDOV  EVDSE  EVACS  EVPSS  EVMSC  EVRER  \\\n",
       "0     16     16      0     39   13.8      0    0.0  34.75   26.1      0   \n",
       "1     16     16      0     39   13.8      0    0.0  34.75   26.1      0   \n",
       "2     16     16      0     39   13.8      0    0.0  34.75   26.1      0   \n",
       "3     16     16      0     39   13.8      0    0.0  34.75   26.1      0   \n",
       "4     16     16      0     39   13.8      0    0.0  34.75   26.1      0   \n",
       "\n",
       "   EVDRV  EVMTR  EVODO  EVOAS  EVHTR  EVACE  EVTRE  EVCLC  EVBFN  EVIST  \\\n",
       "0 -65532      0   2217   15.5      1   14.9    4.0     65      1      0   \n",
       "1 -65532      0   2217   15.5      1   14.9    4.0     65      1      0   \n",
       "2 -65532      0   2217   15.5      1   14.9    4.0     65      1      0   \n",
       "3 -65532      0   2217   15.5      1   14.9    4.0     65      1      0   \n",
       "4 -65532      0   2217   15.5      1   14.9    4.0     65      1      0   \n",
       "\n",
       "   EVHTP_AVG  EVHTP_Max  EVHTP_Min  EVVBT  EVGSM  EVACO_X  EVACO_Y  EVACO_Z  \\\n",
       "0       3920       3920       3920    138      0    684.0   -789.0   -135.0   \n",
       "1       3920       3920       3920    138      0    684.0   -789.0   -135.0   \n",
       "2       3920       3920       3920    138      0    684.0   -789.0   -135.0   \n",
       "3       3920       3920       3920    138      0    684.0   -789.0   -135.0   \n",
       "4       3920       3920       3920    138      0    684.0   -789.0   -135.0   \n",
       "\n",
       "   Unnamed: 164  \n",
       "0           NaN  \n",
       "1           NaN  \n",
       "2           NaN  \n",
       "3           NaN  \n",
       "4           NaN  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = data.groupby(\"tp\").transform(np.random.permutation)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "groups = [data for _, data in data.groupby(\"tp\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "np.random.shuffle(groups)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.concat(groups).reset_index(drop = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "train = df[:623398]\n",
    "test = df[623398:]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "1. EVBRP - constant value\n",
    "2. EVICR - constant value\n",
    "3. EVBCA - constant value"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "train = train[[\"IMEI\", \"sp\", \"EVVSP\", \"EVGPO\", \"EVCFN\", \"EVTRQ\",\n",
    "               \"EVBBV\", \"EVDR1\", \"EVACP\", \"EVPWA_MIN\",\n",
    "               \"EVBMA_Min\", \"EVIRT_Max\", \"EVPSS\", \"EVOAS\",\n",
    "               \"EVODO\", \"EVMCV_MAX\", \"EVBOV_AVG\", \"EVACO_Z\", \"EVSMA_MAX\"]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>IMEI</th>\n",
       "      <th>sp</th>\n",
       "      <th>EVVSP</th>\n",
       "      <th>EVGPO</th>\n",
       "      <th>EVCFN</th>\n",
       "      <th>EVTRQ</th>\n",
       "      <th>EVBBV</th>\n",
       "      <th>EVDR1</th>\n",
       "      <th>EVACP</th>\n",
       "      <th>EVPWA_MIN</th>\n",
       "      <th>EVBMA_Min</th>\n",
       "      <th>EVIRT_Max</th>\n",
       "      <th>EVPSS</th>\n",
       "      <th>EVOAS</th>\n",
       "      <th>EVODO</th>\n",
       "      <th>EVMCV_MAX</th>\n",
       "      <th>EVBOV_AVG</th>\n",
       "      <th>EVACO_Z</th>\n",
       "      <th>EVSMA_MAX</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>623393</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>7259500</td>\n",
       "      <td>7.6328</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>49.9</td>\n",
       "      <td>57.5</td>\n",
       "      <td>0</td>\n",
       "      <td>48.2353</td>\n",
       "      <td>0.15</td>\n",
       "      <td>24.0</td>\n",
       "      <td>80</td>\n",
       "      <td>-99.5</td>\n",
       "      <td>19.5</td>\n",
       "      <td>7047</td>\n",
       "      <td>3.73</td>\n",
       "      <td>246.25</td>\n",
       "      <td>383.0</td>\n",
       "      <td>57.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623394</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>7259600</td>\n",
       "      <td>7.6328</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>49.9</td>\n",
       "      <td>57.5</td>\n",
       "      <td>0</td>\n",
       "      <td>48.2353</td>\n",
       "      <td>0.15</td>\n",
       "      <td>24.0</td>\n",
       "      <td>80</td>\n",
       "      <td>-99.5</td>\n",
       "      <td>19.5</td>\n",
       "      <td>7047</td>\n",
       "      <td>3.73</td>\n",
       "      <td>246.25</td>\n",
       "      <td>383.0</td>\n",
       "      <td>57.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623395</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>7259700</td>\n",
       "      <td>7.6328</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>49.9</td>\n",
       "      <td>57.5</td>\n",
       "      <td>0</td>\n",
       "      <td>48.2353</td>\n",
       "      <td>0.15</td>\n",
       "      <td>24.0</td>\n",
       "      <td>80</td>\n",
       "      <td>-99.5</td>\n",
       "      <td>19.5</td>\n",
       "      <td>7047</td>\n",
       "      <td>3.73</td>\n",
       "      <td>246.25</td>\n",
       "      <td>383.0</td>\n",
       "      <td>57.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623396</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>7259800</td>\n",
       "      <td>7.6328</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>49.9</td>\n",
       "      <td>57.5</td>\n",
       "      <td>0</td>\n",
       "      <td>48.2353</td>\n",
       "      <td>0.15</td>\n",
       "      <td>24.0</td>\n",
       "      <td>80</td>\n",
       "      <td>-99.5</td>\n",
       "      <td>19.5</td>\n",
       "      <td>7047</td>\n",
       "      <td>3.73</td>\n",
       "      <td>246.25</td>\n",
       "      <td>383.0</td>\n",
       "      <td>57.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623397</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>7259900</td>\n",
       "      <td>7.6328</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>49.9</td>\n",
       "      <td>57.5</td>\n",
       "      <td>0</td>\n",
       "      <td>48.2353</td>\n",
       "      <td>0.15</td>\n",
       "      <td>24.0</td>\n",
       "      <td>80</td>\n",
       "      <td>-99.5</td>\n",
       "      <td>19.5</td>\n",
       "      <td>7047</td>\n",
       "      <td>3.73</td>\n",
       "      <td>246.25</td>\n",
       "      <td>383.0</td>\n",
       "      <td>57.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   IMEI       sp   EVVSP  EVGPO  EVCFN  EVTRQ  EVBBV  EVDR1  \\\n",
       "623393  358272088699072  7259500  7.6328     11      1   49.9   57.5      0   \n",
       "623394  358272088699072  7259600  7.6328     11      1   49.9   57.5      0   \n",
       "623395  358272088699072  7259700  7.6328     11      1   49.9   57.5      0   \n",
       "623396  358272088699072  7259800  7.6328     11      1   49.9   57.5      0   \n",
       "623397  358272088699072  7259900  7.6328     11      1   49.9   57.5      0   \n",
       "\n",
       "          EVACP  EVPWA_MIN  EVBMA_Min  EVIRT_Max  EVPSS  EVOAS  EVODO  \\\n",
       "623393  48.2353       0.15       24.0         80  -99.5   19.5   7047   \n",
       "623394  48.2353       0.15       24.0         80  -99.5   19.5   7047   \n",
       "623395  48.2353       0.15       24.0         80  -99.5   19.5   7047   \n",
       "623396  48.2353       0.15       24.0         80  -99.5   19.5   7047   \n",
       "623397  48.2353       0.15       24.0         80  -99.5   19.5   7047   \n",
       "\n",
       "        EVMCV_MAX  EVBOV_AVG  EVACO_Z  EVSMA_MAX  \n",
       "623393       3.73     246.25    383.0       57.5  \n",
       "623394       3.73     246.25    383.0       57.5  \n",
       "623395       3.73     246.25    383.0       57.5  \n",
       "623396       3.73     246.25    383.0       57.5  \n",
       "623397       3.73     246.25    383.0       57.5  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "test = test[[\"IMEI\", \"sp\", \"EVVSP\", \"EVGPO\", \"EVCFN\", \"EVTRQ\",\n",
    "            \"EVBBV\", \"EVDR1\", \"EVACP\", \"EVPWA_MIN\",\n",
    "            \"EVBMA_Min\", \"EVIRT_Max\", \"EVPSS\", \"EVOAS\",\n",
    "            \"EVODO\", \"EVMCV_MAX\", \"EVBOV_AVG\", \"EVACO_Z\", \"EVSMA_MAX\"]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>IMEI</th>\n",
       "      <th>sp</th>\n",
       "      <th>EVVSP</th>\n",
       "      <th>EVGPO</th>\n",
       "      <th>EVCFN</th>\n",
       "      <th>EVTRQ</th>\n",
       "      <th>EVBBV</th>\n",
       "      <th>EVDR1</th>\n",
       "      <th>EVACP</th>\n",
       "      <th>EVPWA_MIN</th>\n",
       "      <th>EVBMA_Min</th>\n",
       "      <th>EVIRT_Max</th>\n",
       "      <th>EVPSS</th>\n",
       "      <th>EVOAS</th>\n",
       "      <th>EVODO</th>\n",
       "      <th>EVMCV_MAX</th>\n",
       "      <th>EVBOV_AVG</th>\n",
       "      <th>EVACO_Z</th>\n",
       "      <th>EVSMA_MAX</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>623398</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>7260000</td>\n",
       "      <td>10.125</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>49.9</td>\n",
       "      <td>57.5</td>\n",
       "      <td>0</td>\n",
       "      <td>45.098</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>12</td>\n",
       "      <td>-99.5</td>\n",
       "      <td>19.5</td>\n",
       "      <td>7047</td>\n",
       "      <td>3.735</td>\n",
       "      <td>246.25</td>\n",
       "      <td>372.0</td>\n",
       "      <td>57.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623399</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>7260100</td>\n",
       "      <td>10.125</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>52.8</td>\n",
       "      <td>57.5</td>\n",
       "      <td>0</td>\n",
       "      <td>45.098</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>12</td>\n",
       "      <td>-99.5</td>\n",
       "      <td>19.5</td>\n",
       "      <td>7047</td>\n",
       "      <td>3.735</td>\n",
       "      <td>246.00</td>\n",
       "      <td>372.0</td>\n",
       "      <td>57.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623400</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>7260200</td>\n",
       "      <td>10.125</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>52.8</td>\n",
       "      <td>57.5</td>\n",
       "      <td>0</td>\n",
       "      <td>45.098</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>12</td>\n",
       "      <td>-99.5</td>\n",
       "      <td>19.5</td>\n",
       "      <td>7047</td>\n",
       "      <td>3.735</td>\n",
       "      <td>246.00</td>\n",
       "      <td>372.0</td>\n",
       "      <td>57.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623401</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>7260300</td>\n",
       "      <td>10.125</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>52.8</td>\n",
       "      <td>57.5</td>\n",
       "      <td>0</td>\n",
       "      <td>45.098</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>12</td>\n",
       "      <td>-99.5</td>\n",
       "      <td>19.5</td>\n",
       "      <td>7047</td>\n",
       "      <td>3.735</td>\n",
       "      <td>246.00</td>\n",
       "      <td>372.0</td>\n",
       "      <td>57.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623402</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>7260400</td>\n",
       "      <td>10.125</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>52.8</td>\n",
       "      <td>57.5</td>\n",
       "      <td>0</td>\n",
       "      <td>45.098</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>12</td>\n",
       "      <td>-99.5</td>\n",
       "      <td>19.5</td>\n",
       "      <td>7047</td>\n",
       "      <td>3.735</td>\n",
       "      <td>246.00</td>\n",
       "      <td>372.0</td>\n",
       "      <td>57.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   IMEI       sp   EVVSP  EVGPO  EVCFN  EVTRQ  EVBBV  EVDR1  \\\n",
       "623398  358272088699072  7260000  10.125     11      1   49.9   57.5      0   \n",
       "623399  358272088699072  7260100  10.125     11      1   52.8   57.5      0   \n",
       "623400  358272088699072  7260200  10.125     11      1   52.8   57.5      0   \n",
       "623401  358272088699072  7260300  10.125     11      1   52.8   57.5      0   \n",
       "623402  358272088699072  7260400  10.125     11      1   52.8   57.5      0   \n",
       "\n",
       "         EVACP  EVPWA_MIN  EVBMA_Min  EVIRT_Max  EVPSS  EVOAS  EVODO  \\\n",
       "623398  45.098        0.0       24.0         12  -99.5   19.5   7047   \n",
       "623399  45.098        0.0       24.0         12  -99.5   19.5   7047   \n",
       "623400  45.098        0.0       24.0         12  -99.5   19.5   7047   \n",
       "623401  45.098        0.0       24.0         12  -99.5   19.5   7047   \n",
       "623402  45.098        0.0       24.0         12  -99.5   19.5   7047   \n",
       "\n",
       "        EVMCV_MAX  EVBOV_AVG  EVACO_Z  EVSMA_MAX  \n",
       "623398      3.735     246.25    372.0       57.1  \n",
       "623399      3.735     246.00    372.0       57.1  \n",
       "623400      3.735     246.00    372.0       57.1  \n",
       "623401      3.735     246.00    372.0       57.1  \n",
       "623402      3.735     246.00    372.0       57.1  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "x_train = train.drop(columns = [\"EVSMA_MAX\"])\n",
    "y_train = train[\"EVSMA_MAX\"]\n",
    "\n",
    "x_test = test.drop(columns = [\"EVSMA_MAX\"])\n",
    "y_test = test[\"EVSMA_MAX\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>IMEI</th>\n",
       "      <th>sp</th>\n",
       "      <th>EVVSP</th>\n",
       "      <th>EVGPO</th>\n",
       "      <th>EVCFN</th>\n",
       "      <th>EVTRQ</th>\n",
       "      <th>EVBBV</th>\n",
       "      <th>EVDR1</th>\n",
       "      <th>EVACP</th>\n",
       "      <th>EVPWA_MIN</th>\n",
       "      <th>EVBMA_Min</th>\n",
       "      <th>EVIRT_Max</th>\n",
       "      <th>EVPSS</th>\n",
       "      <th>EVOAS</th>\n",
       "      <th>EVODO</th>\n",
       "      <th>EVMCV_MAX</th>\n",
       "      <th>EVBOV_AVG</th>\n",
       "      <th>EVACO_Z</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>623398</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>7260000</td>\n",
       "      <td>10.125</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>49.9</td>\n",
       "      <td>57.5</td>\n",
       "      <td>0</td>\n",
       "      <td>45.098</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>12</td>\n",
       "      <td>-99.5</td>\n",
       "      <td>19.5</td>\n",
       "      <td>7047</td>\n",
       "      <td>3.735</td>\n",
       "      <td>246.25</td>\n",
       "      <td>372.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623399</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>7260100</td>\n",
       "      <td>10.125</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>52.8</td>\n",
       "      <td>57.5</td>\n",
       "      <td>0</td>\n",
       "      <td>45.098</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>12</td>\n",
       "      <td>-99.5</td>\n",
       "      <td>19.5</td>\n",
       "      <td>7047</td>\n",
       "      <td>3.735</td>\n",
       "      <td>246.00</td>\n",
       "      <td>372.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623400</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>7260200</td>\n",
       "      <td>10.125</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>52.8</td>\n",
       "      <td>57.5</td>\n",
       "      <td>0</td>\n",
       "      <td>45.098</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>12</td>\n",
       "      <td>-99.5</td>\n",
       "      <td>19.5</td>\n",
       "      <td>7047</td>\n",
       "      <td>3.735</td>\n",
       "      <td>246.00</td>\n",
       "      <td>372.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623401</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>7260300</td>\n",
       "      <td>10.125</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>52.8</td>\n",
       "      <td>57.5</td>\n",
       "      <td>0</td>\n",
       "      <td>45.098</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>12</td>\n",
       "      <td>-99.5</td>\n",
       "      <td>19.5</td>\n",
       "      <td>7047</td>\n",
       "      <td>3.735</td>\n",
       "      <td>246.00</td>\n",
       "      <td>372.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623402</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>7260400</td>\n",
       "      <td>10.125</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>52.8</td>\n",
       "      <td>57.5</td>\n",
       "      <td>0</td>\n",
       "      <td>45.098</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>12</td>\n",
       "      <td>-99.5</td>\n",
       "      <td>19.5</td>\n",
       "      <td>7047</td>\n",
       "      <td>3.735</td>\n",
       "      <td>246.00</td>\n",
       "      <td>372.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   IMEI       sp   EVVSP  EVGPO  EVCFN  EVTRQ  EVBBV  EVDR1  \\\n",
       "623398  358272088699072  7260000  10.125     11      1   49.9   57.5      0   \n",
       "623399  358272088699072  7260100  10.125     11      1   52.8   57.5      0   \n",
       "623400  358272088699072  7260200  10.125     11      1   52.8   57.5      0   \n",
       "623401  358272088699072  7260300  10.125     11      1   52.8   57.5      0   \n",
       "623402  358272088699072  7260400  10.125     11      1   52.8   57.5      0   \n",
       "\n",
       "         EVACP  EVPWA_MIN  EVBMA_Min  EVIRT_Max  EVPSS  EVOAS  EVODO  \\\n",
       "623398  45.098        0.0       24.0         12  -99.5   19.5   7047   \n",
       "623399  45.098        0.0       24.0         12  -99.5   19.5   7047   \n",
       "623400  45.098        0.0       24.0         12  -99.5   19.5   7047   \n",
       "623401  45.098        0.0       24.0         12  -99.5   19.5   7047   \n",
       "623402  45.098        0.0       24.0         12  -99.5   19.5   7047   \n",
       "\n",
       "        EVMCV_MAX  EVBOV_AVG  EVACO_Z  \n",
       "623398      3.735     246.25    372.0  \n",
       "623399      3.735     246.00    372.0  \n",
       "623400      3.735     246.00    372.0  \n",
       "623401      3.735     246.00    372.0  \n",
       "623402      3.735     246.00    372.0  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x_test.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>IMEI</th>\n",
       "      <th>sp</th>\n",
       "      <th>EVVSP</th>\n",
       "      <th>EVGPO</th>\n",
       "      <th>EVCFN</th>\n",
       "      <th>EVTRQ</th>\n",
       "      <th>EVBBV</th>\n",
       "      <th>EVDR1</th>\n",
       "      <th>EVACP</th>\n",
       "      <th>EVPWA_MIN</th>\n",
       "      <th>EVBMA_Min</th>\n",
       "      <th>EVIRT_Max</th>\n",
       "      <th>EVPSS</th>\n",
       "      <th>EVOAS</th>\n",
       "      <th>EVODO</th>\n",
       "      <th>EVMCV_MAX</th>\n",
       "      <th>EVBOV_AVG</th>\n",
       "      <th>EVACO_Z</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>-16.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.15</td>\n",
       "      <td>34.0</td>\n",
       "      <td>16</td>\n",
       "      <td>-298.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>7148</td>\n",
       "      <td>3.88</td>\n",
       "      <td>257.25</td>\n",
       "      <td>396.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>100</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.15</td>\n",
       "      <td>34.0</td>\n",
       "      <td>16</td>\n",
       "      <td>-298.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>7148</td>\n",
       "      <td>3.88</td>\n",
       "      <td>256.25</td>\n",
       "      <td>396.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>200</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.15</td>\n",
       "      <td>34.0</td>\n",
       "      <td>16</td>\n",
       "      <td>-298.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>7148</td>\n",
       "      <td>3.88</td>\n",
       "      <td>256.25</td>\n",
       "      <td>396.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>300</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.15</td>\n",
       "      <td>34.0</td>\n",
       "      <td>16</td>\n",
       "      <td>-298.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>7148</td>\n",
       "      <td>3.88</td>\n",
       "      <td>256.25</td>\n",
       "      <td>396.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>358272088699072</td>\n",
       "      <td>400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.15</td>\n",
       "      <td>34.0</td>\n",
       "      <td>16</td>\n",
       "      <td>-298.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>7148</td>\n",
       "      <td>3.88</td>\n",
       "      <td>256.25</td>\n",
       "      <td>396.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              IMEI   sp  EVVSP  EVGPO  EVCFN  EVTRQ  EVBBV  EVDR1  EVACP  \\\n",
       "0  358272088699072    0    0.0     10      0  -16.0   60.0      0    0.0   \n",
       "1  358272088699072  100    0.0     10      0    0.0   60.0      0    0.0   \n",
       "2  358272088699072  200    0.0     10      0    0.0   60.0      0    0.0   \n",
       "3  358272088699072  300    0.0     10      0    0.0   60.0      0    0.0   \n",
       "4  358272088699072  400    0.0     10      0    0.0   60.0      0    0.0   \n",
       "\n",
       "   EVPWA_MIN  EVBMA_Min  EVIRT_Max  EVPSS  EVOAS  EVODO  EVMCV_MAX  EVBOV_AVG  \\\n",
       "0       0.15       34.0         16 -298.0   16.0   7148       3.88     257.25   \n",
       "1       0.15       34.0         16 -298.0   16.0   7148       3.88     256.25   \n",
       "2       0.15       34.0         16 -298.0   16.0   7148       3.88     256.25   \n",
       "3       0.15       34.0         16 -298.0   16.0   7148       3.88     256.25   \n",
       "4       0.15       34.0         16 -298.0   16.0   7148       3.88     256.25   \n",
       "\n",
       "   EVACO_Z  \n",
       "0    396.0  \n",
       "1    396.0  \n",
       "2    396.0  \n",
       "3    396.0  \n",
       "4    396.0  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x_train.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    74.9\n",
       "1    74.9\n",
       "2    74.9\n",
       "3    74.9\n",
       "4    74.9\n",
       "Name: EVSMA_MAX, dtype: float64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y_train.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "623398    57.1\n",
       "623399    57.1\n",
       "623400    57.1\n",
       "623401    57.1\n",
       "623402    57.1\n",
       "Name: EVSMA_MAX, dtype: float64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y_test.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "xgb_train = xgboost.DMatrix(x_train, label=y_train)\n",
    "xgb_test = xgboost.DMatrix(x_test, label=y_test)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "params = {\n",
    "    \"eta\": 0.002,\n",
    "    \"max_depth\": 3,\n",
    "    \"objective\": \"reg:linear\",\n",
    "    \"subsample\": 0.5\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[0]\ttest-rmse:74.889\n",
      "[1000]\ttest-rmse:10.3774\n",
      "[2000]\ttest-rmse:2.09187\n",
      "[3000]\ttest-rmse:1.34279\n",
      "[4000]\ttest-rmse:1.28933\n",
      "[5000]\ttest-rmse:1.3002\n",
      "[6000]\ttest-rmse:1.32125\n",
      "[7000]\ttest-rmse:1.34559\n",
      "[8000]\ttest-rmse:1.36248\n",
      "[9000]\ttest-rmse:1.37309\n",
      "[9999]\ttest-rmse:1.38199\n"
     ]
    }
   ],
   "source": [
    "model_train = xgboost.train(params, xgb_train, 10000, evals = [(xgb_test, \"test\")], verbose_eval=1000)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7fe1a42d2710>"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAbQAAAEWCAYAAAAO4GKjAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvOIA7rQAAIABJREFUeJzsnXl4VEXWh98DKIJhkwgfgoLsECAZFpFRIagssgougLKJOu4iKoI6KioOIOC+ILKIOCaIKDCjoyAmCMgooAmIGNZgRGQbkASCJOF8f9ybpul0kiamk3Q47/P0k3tru79qMSdVt+pXoqoYhmEYRqhTprgFGIZhGEZhYAHNMAzDKBVYQDMMwzBKBRbQDMMwjFKBBTTDMAyjVGABzTAMwygVWEAzjDMAEZkmIk8Utw7DCCZi+9AMI3dEJBmoCWR5JTdW1V//RJvRwHuqWufPqQtNROQd4BdV/XtxazFKFzZCM4z86a2qYV6fAgezwkBEyhXn8/8MIlK2uDUYpRcLaIZRQETkUhH5WkQOiUiiO/LKzrtFRDaJSKqIbBeRO9z0c4H/ABeISJr7uUBE3hGR8V71o0XkF6/7ZBEZIyLrgSMiUs6tt0BE9onIDhG5Pw+tnvaz2xaRR0Rkr4jsFpFrRaSHiGwWkf+JyGNedceJyIciMs/tz3ciEumV30xE4t3vYaOI9PF57psi8qmIHAFuBW4GHnH7/i+33FgR2ea2/6OI9PNqY7iIrBSRKSJy0O3rNV7554nIbBH51c1f6JXXS0QSXG1fi0irgP8DGyGHBTTDKAAiUhv4BBgPnAc8DCwQkfPdInuBXkBl4BbgRRFprapHgGuAXwsw4hsE9ASqAieAfwGJQG3gKuABEekWYFv/B5zj1n0SeBsYDLQBrgCeFJH6XuX7AvPdvr4PLBSRs0TkLFfHEqAGcB/wTxFp4lX3JuA5oBLwLvBP4Hm3773dMtvc51YBngbeE5FaXm20B5KAcOB5YKaIiJs3F6gIRLgaXgQQkdbALOAOoDrwFrBYRMoH+B0ZIYYFNMPIn4XuX/iHvP76Hwx8qqqfquoJVV0KrAV6AKjqJ6q6TR2W4/zCv+JP6nhFVVNUNR1oB5yvqs+o6nFV3Y4TlAYG2FYG8JyqZgCxOIHiZVVNVdWNwEbAezSzTlU/dMu/gBMML3U/YcBEV8eXwL9xgm82i1R1lfs9HfMnRlXnq+qvbpl5wBbgEq8iO1X1bVXNAuYAtYCabtC7BrhTVQ+qaob7fQPcDrylqt+oapaqzgH+cDUbpZCQnYs3jCLkWlX9wietLnCDiPT2SjsLiANwp8SeAhrj/OFYEdjwJ3Wk+Dz/AhE55JVWFlgRYFsH3OAAkO7+3OOVn44TqHI8W1VPuNOhF2TnqeoJr7I7cUZ+/nT7RUSGAg8C9dykMJwgm81vXs8/6g7OwnBGjP9T1YN+mq0LDBOR+7zSzvbSbZQyLKAZRsFIAeaq6u2+Ge6U1gJgKM7oJMMd2WVPkflbWnwEJ+hl839+ynjXSwF2qGqjgogvABdmX4hIGaAOkD1VeqGIlPEKahcBm73q+vb3lHsRqYszurwKWK2qWSKSwMnvKy9SgPNEpKqqHvKT95yqPhdAO0YpwKYcDaNgvAf0FpFuIlJWRM5xF1vUwRkFlAf2AZnuaK2rV909QHURqeKVlgD0cBc4/B/wQD7P/xY47C4UqeBqaCEi7Qqth6fSRkT6uyssH8CZuvsv8A1OMH7EfacWDfTGmcbMjT2A9/u5c3GC3D5wFtQALQIRpaq7cRbZvCEi1VwNHd3st4E7RaS9OJwrIj1FpFKAfTZCDAtohlEAVDUFZ6HEYzi/iFOA0UAZVU0F7gc+AA7iLIpY7FX3JyAG2O6+l7sAZ2FDIpCM875tXj7Pz8IJHFHADmA/MANnUUUwWAQMwOnPEKC/+77qONAH5z3WfuANYKjbx9yYCTTPfiepqj8CU4HVOMGuJbDqNLQNwXkn+BPOYpwHAFR1Lc57tNdc3VuB4afRrhFi2MZqwzDyRETGAQ1VdXBxazGMvLARmmEYhlEqsIBmGIZhlApsytEwDMMoFdgIzTAMwygV2D60IqRq1arasGHD4pYREEeOHOHcc88tbhkBE0p6TWvwCCW9pjVw1q1bt19Vz8+vnAW0IqRmzZqsXbu2uGUERHx8PNHR0cUtI2BCSa9pDR6hpNe0Bo6I7AyknE05GoZhGKUCC2iGYRhGqcACmmEYhlEqsIBmGIZhlAosoBmGYRilAgtohmEYRqnAApphGIYRMCNGjKBGjRq0aJHzhJ8pU6YgIuzfvx8AVeX++++nYcOGtGrViu++++6U8ocPH6Z27drce++9AKSmphIVFeX5hIeH88AD+Z2kdBILaIZhGEbADB8+nM8++yxHekpKCkuXLuWiiy7ypP3nP/9hy5YtbNmyhenTp3PXXXedUueJJ56gU6dOnvtKlSqRkJDg+dStW5f+/fsHrC1oAU1EskQkweszVkTGicgEn3JRIrLJvU4WkRU++Qki8oPX/SUi8pWIJInITyIyQ0Sai8gv7km6vnUvyUXfOBFREWnolTbKTWvrlfYXN62bV9qFIrJDRM5z76u593UL9m0ZhmGEBh07duS8887LkT5q1Cief/55RE4eNL5o0SKGDh2KiHDppZdy6NAhdu/eDcC6devYs2cPXbt2zdEWwJYtW9i7dy9XXHFFwNqC6RSSrqpR3gki0gTndNlHvZIHAu973VcSkQtVNUVEmvnUrwnMBwaq6mpxvrnrgAM4ByxeASx3yzYFKqnqt3lo3OA+f7x7fz3wo0+ZQcBK9+fn4BzuKCJvAhOBv7k/p6tqnrvZ0zOyqDf2k7yKlBgeapnJ8BDRCqGl17QGj1DSG2pao/PIX7x4MbVr1yYyMvKU9F27dnHhhRd67uvUqcOuXbuoWbMmDz30EHPnzmXZsmV+24yJiWHAgAGnBMj8KFLrK1VNck+pba+q37jJNwLdvIp9gHMy7hScIBKDcyItwD3AHFVd7banwIcAIhKDE5yWu2UHunXzYiHOqcPjRaQ+8DvOybe4bQpOkOsCrBCRc1T1mJv9IrBORB4ALgfu8/cAEfkbTtAjPPx8nmyZmY+kkkHNCs4/4lAhlPSa1uARSnpDTWt8fLzn/rfffuPIkSPEx8dz7NgxxowZw+TJkz33q1atokqVKuzfv5/vv/+ezEynnwcPHmTdunXMnTuXJk2asG3bNn766Sd27dp1SvsAs2bN4tFHH82RnhfBDGgVRCTB636Cqs7DCTIDgW9E5FLggKpu8Sr3IfAOTkDrDdzMyYDWApiTy/M+AL4XkftUNRMnKN6Qj8bDQIqItMAJbPOAW7zyLwN2qOo2EYkHegAfAahqhoiMBj4DurpH0edAVacD0wEuqt9Qp24IDfvMh1pmEipaIbT0mtbgEUp6Q03rjV5ejsnJyZx77rlER0ezYcMGDhw44FnYsX//fu677z6+/fZbIiMjCQ8P9/hAHjlyhD59+vDVV1+xYsUKPv/8c9LS0jh+/DhNmjRh4sSJACQmJnL22Wdzxx13nJ5QVQ3KB0jLJf1CnOnBMsBLwINeeclAOPAJJ6ci6wE/uPkfAX3zeOYXOKO9KGB9PvrGAQ/jjBDHA2uAykA80NYt8zpwu3vdB5jv08ZLwK/AqEC+k8aNG2uoEBcXV9wSTotQ0mtag0co6Q1lrTt27NCIiAi/ZevWrav79u1TVdV///vf2r17dz1x4oSuXr1a27Vrl6P87Nmz9Z577jklbcyYMfrkk0967oG1GsDv2CJf5aiqKTiBqxPO+68P/BSbhxNMfKcMNwJt8mg+e/QXyHRjNv/CGQH+rKqHsxNFpKyr70kRSQZeBa4RkUpufhTOVOSlwCgRqRXg8wzDMEKWQYMG0aFDB5KSkqhTpw4zZ87MtWyPHj2oX78+DRs25Pbbb+eNN94I6BkffPABgwYNOm1txTXejcF5B7VNVX/xk/8xUAtnEcYFXumvAd+KyCfqvoMTkcHAF6r6G7AA+AdwFLgyECGqmi4iY4DNPllXA4mq6r26cQ5wrYi8B7wJPKCqP4vIZJwp0psDeaZhGEaoEhOT91ghOTnZcy0ivP7663mWHz58OMOHDz8lbfv27QXSFswRWgWfZfsTvfLmAxFArL+KqpqqqpPU572Uqu7BGX1NcZftb8JZ2XjYzT8E/BfYo6o7AhWqqrGq+p1P8iCcwOrNAuAm4HacEd1SN/0NoKmIdMIwDMMoFoI2QlPVsnnk7QPO8pNez09aMs5ikOz71ThBLLe2+waob1wu6dHu5XA/eYuBxe7tdK/0LPKeCjUMwzCCjDmFGIZhGKWCUh/QRORxn6nPBBF5vLh1GYZR8vDnU/i///2PLl260KhRI7p06cLBgwc9efHx8URFRREREeGxcEpKSjrFj7By5cq89NJLAAwYMMCTPnDgQKKiojAKj1If0FT1OVWN8vk8V9y6DMMoefjzKZw4cSJXXXUVW7Zs4aqrrvLslTp06BB33303ixcvZuPGjcyfPx+AJk2aeLwI161bR8WKFenXrx8A8+bN8+R17NjxtHwKjfwJekD7E56OG9zyG0Skr1e5OiKySES2iMg2EXlZRM4WkXNF5ICIVPFpd6GI3JiPxkUistrrPtr73k0rJyJ7spfni8iDrpfkBhFJFJEXRCTHe0HDMEIHfz6FixYtYtiwYQAMGzaMhQsXAvD+++/Tv39/jxlvjRo1crS3bNkyGjRoQN26p9q8qirx8fEFWppu5E5RLNsvqKdjZ1Xd75ZdAixyrag+At5U1b7uXrHpwHOqOlpElgDX4rqJuMHtcpyViX4RkapAayBNRC52V0d+BdQRkXruohRwlvH/oKq7ReROoCtwqaoeEpGzgQeBCnhZZ+X4IszLMWiEkl7TGjwKqjd5Ys9c8/bs2UOtWs4201q1arF3714ANm/eTEZGBtHR0aSmpjJy5EiGDh16St3Y2Fi/QWvFihVUq1aNRo0anbZWI3eKZcpRVZOAQyLS3iv5Rvwv468MZE9aXwkcU9XZbjtZwChghIhU5OTG6mz6AZ+p6tE85FyHs7k6Nruuqp7A2VowwKuc92btx4G73G0CqOpxVZ3ovTHbMIzSTWZmJuvWreOTTz7h888/59lnn2Xz5pPbWY8fP87ixYu54YacDnwxMTFcddVVRSn3jKAoRmgF9XSMc0dk9XGCHTh719Z5N66qh0XkZ6Ahjq/iDBGprqoH3PZfzUffIOBpYA+Oj2T2VGgMzuhvkoiUx/FxHOU6hYQFus/NzImLhlDSa1qDR0H15ma8C1C5cmUWLFhA9erVOXDgAJUqVSI+Pp7jx4/TtGlT1qxZA0CjRo14//33Pb6FK1eu5OKLL2bTpk1s2rTJ035WVhbz5s3jhRdeOC3j3eIkLS0tNLQG4o/1Zz78CU9H97qBex8GjARe8NNWAtDSvZ4B3IHjCfkbcFYe2mq6bYt7/x3Qwit/C9AEZxpzsZtWGfifV5lu7vOTgb/m9V2Yl2PwCCW9pjV4FIZeX5/Chx9+WCdMmKCqqhMmTNDRo0erquqPP/6oV155pWZkZOiRI0c0IiJCN2zY4Kk3YMAAnTVrVo72//Of/2jHjh1D6rstbq2UVC/HbDQwT0dUdRvO6Kk5jpdjW+98EamMExy3uUnZI7/rgUWqmus7LZwpxWrADtevsR6nTllmT0N6phvVmVY8IiIXu/efq/OO8Afg7Hw7bhhGicWfT+HYsWNZunQpjRo1YunSpYwdOxaAZs2a0b17d1q1asUll1zCbbfd5lnuf/ToUZYuXep3FWNu79WMP09xn12Qn6cjIlIDuBjYCewFJorIUFV9110UMhV4R0++J4vDWRRyD7mcUebFIKC7uueruUFqKfB3L32LgCrArV71JgBvishAdRaFCHDOafTbMIwSSG4+hbkdQjl69GhGjx6dI71ixYocOHDAb5133nkHIDSm8EKMohihFdTTMc599xYHjFXVPe7Qsx9wg4hswTEUPgY8ll1JnQUdC4DqOKsV/SIi9YCLcLwfs+vuAA5nL1ZR1R9xjI6/VNUjXtXfxDmq5hsRWQ+sAr53P4ZhGEYxEPQRmhaSp6NXXgrOwZ95PXMkzvu2vMokA7X9pLf2uY/0U0Zx3PWn5PUMwzAMo+go9U4hhmEYxpnBGRHQROQWP36OeR/SYxgGP//8s19fwsTERDp06EDLli3p3bs3hw8fzlEvLCyMKVOcSYyUlBQ6d+5Ms2bNiIiI4OWXXy6O7hilnOJeFFIkqLMRe3Zx6zCMUOOiiy4iIcHZRpqVlUXt2rXp168f119/PVOmTKFTp07MmjWLyZMn8+yzz3rqjRo1imuuucZzX65cOaZOnUrr1q1JTU2lTZs2dOnShebNmxd5n4zSyxkxQjMM48/j7UuYlJREx44dAejSpQsLFizwlFu4cCH169cnIiLCk1arVi1at3ZeT1eqVIlmzZqxa9euou2AUeo5I0ZofxYRORdnn1wdoCzwLDAJmAd0dovdpKpb82rHvByDRyjpDRWtvv6G3vunWrRoweLFi+nbty/z588nJSUFgCNHjjBp0iSWLl3qmW7M0W5yMt9//z3t27f3m28YBcVGaIHRHfhVVSNVtQWOxRbAYVW9BHgNx+3EMEolvr6Es2bN4vXXX6dNmzakpqZy9tmOp8BTTz3FqFGjCAsL89tOWloa1113HS+99BKVK1cuMv3GmUG25ZORByLSGPgcZ5T2b1Vd4TqLXKmq291jY35T1ep+6np7ObZ58qW3i1B5walZAfakF7eKwAklvaGitWXtKqSlpREWFsbKlStZtGgRkydPzlEuJSWFf/zjH7z55pvcf//9Hjf6tLQ0ypQpwy233EK/fv3IzMzk0UcfpV27dtx4Y54nOhWYbL2hgGkNnM6dO69T1bb5FgzEH8s+CnAeMBhYCTyJY9t1sZt3FrA/vzbMyzF4hJLeUNTq60u4Z88eVVXNysrSIUOG6MyZM3PUfeqpp3Ty5MmqqnrixAkdMmSIjhw5skj0hgKmNXAo6V6OoYSIXAAcVdX3cDZTZ2++HuD1c7W/uoYR6vjzJYyJiaFx48Y0bdqUCy64gFtuuSXPNlatWsXcuXP58ssvPVsAPv3002BLN84wbFFIYLQEJovICZwDPO/COWqmvIh8g/Mu0txGjVKJP1/CkSNHMnJknmY8jBs3znN9+eWXZ890GEbQsIAWAKr6Oc47NA+OHzGvq+rTxSLKMAzDOAWbcjQMwzBKBTZCKyCah4GyYRiGUfTYCM0wDMMoFdgIzTDOUJKSkhgwYIDnfvv27TzzzDMcOnSIt99+m/PPP5+0tDReeeUVevToAcCECROYOXMmZcuW5ZVXXqFbt24A1KtXj0qVKlG2bFnKlSvH2rVri6VPxplNqQhoIpIFbPBKisU5Qbq8qj7qVS4KiFHVZiJSBXgVuMzNXgXcp6q/u4d/bgJ+cttJxVkAMserrWuBZ4CzcVY+PqGqC4PTQ8MofJo0aeLXeHj27NmMGjWKhx9+mPj4eKKjowH48ccfiY2NZePGjfz6669cffXVbN68mbJlnSMP4+LiCA8PL67uGEbpCGhAuqpGeSeISBPgP8CjXskDgffd65nAD6o61C3/NDADuMHN36aqf3Hz6gMfiUgZVZ0tIpE4+9G6qOoOEbkYWCoi21V1fa4izcsxaISS3pKg1den0dt4ODcWLVrEwIEDKV++PBdffDENGzbk22+/pUOHDsGWaxgBUWrfoalqEnBIRLwdUG8EYkWkIdAGx2Q4m2eAtiLSwE9b24EHgfvdpIeBf6jqDjd/BzABGF3oHTGMIsDbeBjgtddeo1WrVkyaNImDBw8CsGvXLi688EJPmTp16ngc80WErl270qZNG6ZPn1604g3DpbSM0CqISILX/QRVnQfE4IzKvhGRS4EDqrpFRPoACaqalV1BVbPcNiIAf6Os74Cm7nUEzgjNm7XAPb6VfLwcebJlZoE6WNTUrOCMJEKFUNJbErTGx8d7rjMyMliwYAG9evUiPj6eVq1aMXPmTESEadOmcdNNNzFmzBh++eUXNm3a5Km7e/duNm7cSHh4OJMnTyY8PJyDBw/y8MMPk56eTmRkZJH3Ky0t7ZS+lWRMa+FTWgJajilHl1jgaxF5CCewxbjpAvizLcgtPTsvr3J+66rqdGA6QJMmTfS+m/vm1ocSRXx8PDe6705CgVDSW9K0Llq0iPbt259ibZXN3r17GT9+PNHR0axe7bi7Zb9TmzBhAl27ds0x5ZiYmEhGRoanXFHi/c6vpGNaC59SO+UIoKopOCbCnYDrcNzyATYCfxERT//d60icxSD++ItX3kbA1/m5NfBjoQg3jCIkJibmlOnG3bt3e65XrFhBixYtAOjTpw+xsbH88ccf7Nixgy1btnDJJZdw5MgRUlNTAec8tCVLlnjqGEZRUlpGaHkRA7yIs8jjFwBV3Soi3wN/x3l3hnv9nZtXz7sB934KzqpI3Ov5IvKlqia7+Y8B1wezI4ZR2GQbD7/11luetEceeYSEhAREhEqVKvHhhx8CEBERwY033kjz5s0pV64cr7/+OmXLlmXPnj3069cPgMzMTG666Sa6d+9eLP0xzmxKS0DzfYf2maqOda/nAy8D9/nUuRV4VUS24kwXrnbTsmngBr3sZfuvqupsAFVNEJExwL/cs9AygEdUNQHDCCH8GQ/PnTvXcx0fH0+tWrU8948//jiPP/74KeXr169PYmJicIUaRgCUioCmqmXzyNuHc16Zb/pBnPPN/NVJBirk88yPgI9OS6hhGIYRNEr1OzTDMAzjzMECmmEYhlEqsIBmGEXMwIEDadmyJVFRUbRt6yyWTUxMpEOHDrRs2ZLevXtz+PBhAL799lvPCc+RkZF8/PHHAKSkpNC5c2eaNWtGREQEL7/8crH1xzBKCqXiHZphhBq+voe33XYbU6ZMoVOnTsyaNYvJkyfz7LPP0qJFC9auXUu5cuXYvXs3kZGR9O7dm3LlyjF16lRat25Namoqbdq0oUuXLjRv3rwYe2UYxUuRjtBEJEtEErw+Y0VknIhM8CkXJSKb3OtkEdnglt8gIn29yqmIzPW6Lyci+0Tk3z7tLRKR1QHoG+e22dArbZSb1ta9/1REqhb8WzCMnCQlJdGxY0cAunTpwoIFCwBnFWK5cs7fnceOHcs+KZ1atWrRunVrACpVqkSzZs08NlSGcaZS1CO0gpgIA3RW1f1u2SXAIjf9CNBCRCqoajrQBTjl/2o3+LQG0kTk4mz/xTzY4D5/vHt/PV4bplW1R/7d9I+ZEwePUNGbPLGnx/dQRLjjjjv429/+RosWLVi8eDF9+/Zl/vz5pKSkeOp88803jBgxgp07dzJ37lxPgPO0mZzM999/T/v27X0fZxhnFKKam9NTEB4mkqaqYX7SvwPuUtVv3PvtQDfXdzEZaOsGtHbA29lBUUTSgFdwNkR/KCLv4rh4XKGqvdwyt+IYEe8BjqvqBN/ne+kYhzNqvUZV27ku+68BFYGHVXVtth4gDCcQrwT+ihNI+7qB1btNby/HNk++9PZpf2/FQc0KsCc9/3IlhVDR27J2FXbu3EndunU9vof3338/1apV49VXX+X333/nsssu46OPPmLRokWn1N25cycTJ07k5Zdf5uyzzwYgPT2dkSNHMnjwYM8IrzBJS0sjLCzH/7IlllDSa1oDp3PnzutU1dedKSeqWmQfIAtI8PoMcNNHAy+615cCa7zqJOOMmn4AjgK9vPLSgFbAhzgboBOAaODfXmW+AK4AGgPr89E3DsdJ/yOgBfA4MAyIxwmq2XrCgXpAJhDlpn8ADM6r/caNG2uoEBcXV9wSTotQ0uut9amnntLJkyefkp+UlKTt2rXzWzc6OlrXrFmjqqrHjx/Xrl276tSpU4tEaygQSnpNa+AAazWAGFPUqxzTVTXK6zPPTY8Frnf9FL1NhLPprKotgJbAayLi+VNBnfPH6gGDgE+9K4lITaAhsFJVNwOZIhKIyVysq+Na4OM8yu3Qk+4g61wdhpErR44c4ejRo57rbN/DvXv3AnDixAnGjx/PnXfeCcCOHTvIzHSc+Xfu3ElSUhL16tVDVbn11ltp1qwZDz74YPF0xjBKGCVi2b7mbiLsW24bztSh71KuxTj+ir6BcABQDdjhThXWwwlU+fEvYAjws6oezqPcH17XWdiqUSMf9uzZw3333UdkZCSXXHIJPXv2pHv37sTExNC4cWOaNm3KBRdcwC233ALAypUriYyMJCoqin79+vHGG28QHh7OqlWrmDt3Ll9++aVnWf+nn36az9MNo3RTkn4B5zAR9kVEagAXAzt9smYBv6vqBhGJ9kofBHRX1dVu/YuBpThGxLmiqumuV+PmgnTEMHKjfv36zJw5M8dRHCNHjmTkyJE5yg8ZMoQhQ4bkSL/88suzp8kNw3Ap6oBWEBNhgDgRycLxZByrqnu8M90AeMrOUtcB/yLgv17ldojIYRFpr+4ClNxQ1djAumQYhmGUBIo0oGnBTITr5VEnx7IbVY3HWcQBUNtPfus82huXS3q0Hz37cRaOZKf7nmBtGIZhFCEl4h2aYRiGYfxZzsiAJiKP+ziWJIjI4/nXNAz/1KtXL4c/4xNPPEGrVq2Iioqia9eu/Prrr4Czp6d3795ERkYSERHB7NmzPe10796dqlWr0qtXr2Lph2GEMqUyoOVnsaWqz6mzOXs4UB5n/9p+nzauFZFP3evHRWSjiKx322vvpseLSJKIJIrIKtfJxDhDiYuLIyEhgbVr1wIwevRo1q9fT0JCAr169eKZZ5zD0RcuXEjz5s1JTEwkPj6ehx56iOPHj3vqeB+waRhG4JTKgEbO/W4TcVZRDvApl22xFUPO5fwDgRgR6QD0AlqraivgaiDFq9zNqhoJzAEmB6EvRohSuXJlz/WRI0c8PowiQmpqKqpKWloa5513nsfO6qqrrqJSpUrFotcwQp2StGw/qKhqkogc8lnheCPQDdgOvCMitVR1t4hUxAlct+P4Q+5X1T/cdvb7ax/4CnggLw3m5Rg8iktv8sSeAH79GQEef/xx3n33XapUqUJcXBwA/fr1Y/LkyVxwwQWkpqYk7WSPAAAgAElEQVQyb948ypQprX9bGkbRUaRejkWFu8R/g1fSBFWdJyKjgQtUdZSIXAq8qqrt3DqvA5tV9WURGQhcp6o3uK4kK3H8HL8A5qnqcrdOPCc9Hkfj2GOdMgo0L8eiobj0tqxdBYD9+/cTHh5+ij9jZGSkp9w///lPjh8/zi233MLnn3/O1q1bufvuu/n11195+OGHmTFjBueeey4ACQkJzJs3jwkTcrUdLTKK28PvdAklvaY1cEqkl2NRfYC0XNIvxJkuLAO8BDzolXc5sNq9Xgj098ori+MR+TTwGzDcTY8HknDewS0ELsxLl3k5Bo+SpNefP2NycrJGRESoqmr79u31q6++8uR17txZv/nmG899XFyc9uzZs2jE5kNJ+l4DIZT0mtbAoYR6ORYrmrfF1iqglohE4rjnf+pVL0tV41X1KeBet242N6vznu5at33jDOPIkSOkpqZ6rrP9Gbds2eIps3jxYpo2bQpAzZo1WbZsGeBYYSUlJVG/fv2iF24YpYwz5h2aF34ttlRVReQDnMUdn6rqMfCc13ZCVbN/O0WR03rLOIPZs2cP/fr1AyAzM5ObbrqJ7t27c91115GUlESZMmWoW7cu06ZNAxw7q+nTp9OyZUtUlUmTJnlOr77iiiv46aefSEtLo06dOsycOZNu3boVW98MI5QorQGtoBZbMThH2Yz1SgsDXnUPCs0EtuK+EzMMcPwZExMTc6RnnzrtS3h4OEuWLPGbt2LFikLVZhhnEqUyoGkBLLbcvO8B8UlbhzMF6a98dMFVGoZhGIXJGfUOzTAMwyi9WEAzDMMwSgUW0AwjD7KysvjLX/7i8Vb88ssvad26NS1atGDYsGGe06QXLVrk8W1s27YtK1eu9LTx888/07VrV5o1a0bz5s357bffiqUvhlHaKVUBLT8PR69yUSKyyb2uIiLvisg29/OuiFTxKT9KRI55p4tIRRH5p4hsEJEfRGSluwnbKEW8/PLLNGvWDIATJ04wbNgwYmNj+eGHH6hbty5z5swBHMuqxMREEhISmDVrFrfddpunjaFDhzJ69Gg2bdrEt99+S9WqVYulL4ZR2ilVAY3T93AEmAlsV9UGqtoA2AHM8Ck/CFgD9PNKGwnsUdWWqtoCuBXIKOT+GMXIL7/8wieffOIJTgcOHKB8+fI0btwYgC5dunhWMoaFhXm8Gr19G3/88UcyMzPp0qWLp9w555xT1F0xjDOCUrnK0RvNw8NRRBoCbTg14D0DbBWRBqq6TUQa4CzdHw08BrzjlquF1340VU3KT4t5OQaPwtabPLEnDzzwAM8//7xn03R4eDgZGRmsXbuWtm3b8uGHH5KScnIv/ccff8yjjz7K3r17+eQTR8vmzZupWrUq/fv3Z8eOHVx99dV079690HQahnGS0hbQfPefTVDVeZx00//G9XA8oKpbRKQPkKCqWdkVVDXLbSMC2IYzOosBVgBNRKSGqu4FZgFLROR6YBkwx2vztQcfL0eebJkZhG4XPjUrOEEiVChsvRMmTCAjI4PU1FQSEhI4cOAAy5cv55FHHmHEiBFkZGTQtm1bjh07Rnx8PADVqlVj2rRpJCYmcu+99zJ16lTPETHTp0+nZs2aPP300/zxxx+ULZvrzpISRVpamqd/oUAo6TWtQSAQf6xQ+XCaHo5AX+AjP+UXAr3d6x+ARu71C8A9XuXCgP7AG8AhoFle+szLMXgUtt6xY8dq7dq1tW7dulqzZk2tUKGC3nzzzaeU+fzzz/WGG27wW79evXq6b98+Xb16tXbq1MmT/u6772rfvn0LVWswOdP/HQQT0xo4mJfjSTR3D8eNwF9ExPM9uNeRwCYRaQU0ApaKSDLOKG+QV7tpqvqRqt4NvAf0CH5vjKJgwoQJ/PLLLyQnJxMbG8uVV17Je++9x969ewH4448/mDRpEnfeeScAW7duzf4jh++++47jx49TvXp12rVrx8GDB9m3bx/grJKsW7du8XTKMEo5Z0RAc8nh4aiqW4Hvgb97lfs78J2bNwgYp6r13M8FQG0RqSsil4lINQARORtojnk8lnomT55Ms2bNaNWqFb179+bKK68EHJurFi1aEBUVxT333MO8efMQEcqWLcuUKVO46qqrPN6N2VsADMMoXEr7O7RAPBxvxfFq3Ipje7XaTQNnRHaNT/mP3fTdwJviLGcrA3wC+DfvM0Ka6OhooqOjASegTZ6c82DyMWPGMGbMGL/1u3Tpwvr16z33IfEuwjBCkNMOaO6o5EJVXZ9v4SJGC+DhqKoHgcG51LnYT9qDXrfvFkCmYRiGEQQCmnIUkXgRqSwi5wGJwGwReSG40gzDMAwjcAJ9h1ZFVQ/jrOibraptgKuDJ8swDMMwTo9AA1o5EamFsyH530HUYxgBcezYMS655BIiIyOJiIhg9uzZACxbtozWrVsTFRXF5ZdfztatWwFnVeKAAQNo2LAh7du3Jzk52dPW+vXr6dChAxEREbRs2ZJjx44VR5cMw/iTBPoO7Rngc2CVqq4RkfpAjk3ExY2IZAEbvJJigXOA8qr6qFe5KJxVj4eB8sB5QAVgl1vkWiAeSAUUOAgMVdWdbv06wOs4KxvLAp8CD6nqH8Hqm3Eq5cuX58svvyQsLIyMjAxatWrFf//7X+666y4WLVpEs2bNeOONNxg/fjzvvPMOM2fOpFq1amzdupXY2FjGjBnDvHnzyMzMZPDgwcydO5fIyEgOHDjAWWf5PS7PMIwSTkAjNFWdr6qtVPUu9367ql4XXGkF4rS8HFW1vapGAU8C87zqJbvlOqtqK5zg9ncAd1XjR8BCVW2Es0+tAvB8sDtnnERECAtzvKAzMjLIyspCRBARDh8+DMDvv//OBRdcADhu+MOGDQPg+uuvZ9myZagqS5YsoVWrVkRGRgJQvXr1kHHxMAzjVAIaoYlIY+BNoKaqtnA3HPdR1fFBVVcIaB5ejqfRzGrgfvf6SuCYqs52288SkVHAThF5XFXTcmvEvBwLj+SJPcnKyqJNmzZs3bqV3r170759e2bMmEGPHj2oUKEClStX5r///S8Au3bt4sILLwSgXLlyVKlShQMHDrB582ZEhG7durFv3z4GDhzII488UpxdMwyjgAQ65fg2jjnvWwCqul5E3gdKWkA7LS/H02i3O44dFjgej+u8M1X1sOsk0hDwfr55OQaJ7L1cL730EmlpaTz22GPMnj2b2bNn8+yzz9K8eXNiY2MZNGgQo0ePJi0tjdWrV3P++ecDzju4VatWkZSUxBdffMG0adMoX748Dz30EGXLlqVNmzZB0x4yvniEllYILb2mtfAJNKBVVNVvs4/EcCmJv+3S3SlEX2KBr0XkIZzAFhNge3EiUhPYy0k3EcF5r+aL+ElDVacD0wGaNGmi993cN8BHFy/x8fHc6G4mDgUWLFjA/v372bVrF3fffTcA9evXp3v37kRHR9OkSRPq1KlDhw4dyMzM5I8//qBPnz6kp6eTnp5O377Of5c1a9Zw4sQJz0bqYBAfHx/U9guTUNIKoaXXtBY+ga5y3O8eo6IArsP87qCpKmTy8HLMj85AXRzPx2fctI1AW+9CIlIZqAnke4SMUTjs27ePQ4cOAZCens66deto1qwZv//+O5s3bwZg6dKlnsM5+/Tp4zmM88MPP+TKK6/0TDWuX7+eo0ePkpmZyfLly2nevHnxdMowjD9FoCO0e3BGGU1FZBfOIZg3B01VcMjh5RgIqpouIg8AG0RkPM5RMRNFZKiqvisiZYGpwGuqmh4U5UYOdu/ezbBhw8jKyuLEiRO0a9eOXr168fbbb3PddddRpkwZqlWrxqxZswC49dZbGTJkCA0bNuS8884jNjYWcI58efDBB2nXrh0iQo8ePejZs2dxds0wjAKSb0Bz3efbqurVInIuUEZVU4MvrUAUxMsxX1R1t4jE4Bwd86yI9ANeF5EngPNxVkg+92fFG4HTqlUrvv/+e8999vx+v3796NevX47y55xzDvPnz/fb1uDBgxk82K/7mWEYIUS+AU1VT4jIvcAHqnqkCDQVmIJ4Obp573DyJOrstHo+9/d5XacAfQBE5K9AjIi0UdVTFosYhmEYRUegU45LReRhYB7gCWqq+r+gqAohVPVrnPdshmEYRjESaEAb4f68xytNgfqFK8cwDMMwCkagTiEX+/lYMDOKFF//xqeeegoAVWXGjBk0btyYZs2a8corrwCOO0irVq2Iioqibdu2rFy50tNW9+7dqVq1qh22aRiliECdQob6S1fVEnce2On6OapqM/f+L8B3QHdV/dyr3P8BLwHtgD9wlv8/ABwHNuEs1T8b+Aq4W1VPBK1zZzi+/o2XX34511xzDZs2bWLv3r389NNPlClThr179wJw1VVX0adPH0SE9evXc+ONN/LTTz8BMHr0aI4ePcpbb71VnF0yDKMQCXQfWjuvzxXAONxFESWQ0/Jz9LofBKx0fwIe38aPgXhVbaCqzYHHcPacgbMFIApohWNUfG1QemQAOf0bMzIyEBHefPNNhg0bRpkyzj/nGjVqABAWFka2GcCRI0c81+AEu0qVKhVxDwzDCCYBjdC8V/gBiEgVYG5QFAWB/Pwc3cB1PdAFWCEi56jqMZyN1RmqOs2rrQS3Tj2vtEwR+RrH+ipXzMux4CRPdPaGefs33nPPPbRv355t27YRFxfHiy++yPnnn88rr7xCo0aNAPj444959NFH2bt3L598UnL6YxhG4RPoohBfjuK4zJdECuLneBmwQ1W3iUg80APHUb8FPr6N/hCRisBVOK79vnnm5VgIePvIZfs3PvHEEzRt2pSjR4+iqkyZMoWvvvqK6667zvMerVq1akybNo3ExETuvfdepk6d6mknISGBAwcOFLlHXaj44kFoaYXQ0mtag4Cq5vsB/gUsdj//BrYDkwKpW9QfIC2X9AuBFJxp1peAB73yXgdud6/7APPd6/uBF3Nprx6QjmNG/D0wLj9tjRs31lAhLi6uuCXky7hx43Ty5MnapEkTjYmJUVXVEydOaOXKlf2Wr1evnu7bt89zHxcXpz179iwSrd6EwnebTShpVQ0tvaY1cIC1GsDv/0BHaFO8rjOBnXoa9lElAVVNcR3xs/0cOwC41lXXAX1E5HEck+HqIlIJx7fx+jyazX6HZhQB+/bt46yzzqJq1aqkp6fzxRdfMGbMGK699lq+++47Bg4cyPLly2ncuDEAW7dupUGDBogI3333HcePH6d69erF3AvDMIJFoAGth6qO8U4QkUm+aSGAPz/Hq4FEVfWcjyYic3AWeLwH/ENEblfVt928dkBFYGeRKjdy+DfeeOON9OrVi8svv5zu3bvTsmVLwsLCmDFjBuA48L/77rucddZZVKhQgXnz5nkWhlxxxRX89NNPpKWlUadOHWbOnEm3bqdzRJ5hGCWNQANaF8A3eF3jJ60kcLp+joNwVjJ6swC4S1Xnur6NL4nIWOAYJ5ftG0WMr39jNlWrVmXixIk5jrcYM2YMY8b4/ye6YsWKYEg0DKMYyTOgichdwN1AfRFZ75VVCVgVTGEFRU/Tz1FVh/spl/2+EFX9FWdFpD9aFFioYRiGUajkN0J7H/gPMAEY65WequbjaBiGYZQg8gxoqvo78DvuZmMRqYHjuhEmImGq+nPwJRqGYRhG/gTkFCIivUVkC87Bnstx3iP9J4i6jBLAiBEjqFGjBi1anJxZTUxMpEOHDrRs2ZLevXtz+PBhT9769evp0KEDERERtGzZkmPHjgFw/Phx/va3v9G4cWOaNm3KggULirwvhmGUfgK1vhoPXApsVtWLcTYRl8h3aEbhMXz4cD777LNT0m677TYmTpzIhg0b6NevH5MnTwYgMzOTwYMHM23aNDZu3Eh8fDxnneW8rnzuueeoUaMGmzdv5scff6RTp05F3hfDMEo/gQa0DFU9AJQRkTKqGgcEvP9KRLJEJMHrM1ZExonIBJ9yUSKyyb1OFpENIpIoIktE5P9EZKSIvORV/i0R+cLr/j4RecXrvp+IqIg0zUdfPbfcs15p4SKSISKvuffj3DPhEJF3RGSXiJT3Kpsc6PcRKnTs2JHzzjvvlLSkpCQ6duwIQJcuXTyjrSVLltCqVSsiIyMBqF69OmXLOutzZs2axaOPOr7QZcqUITw8vKi6YBjGGUSgy/YPiUgYsAL4p4jsxdlgHSjpvhuQRaQJzrTlo17JvobBnVV1v4j8A8cUeC5ws1d+FE6QLauqWcBfgYVe+dmGwwNxDJXzYjvQC3jCvb8BZ2N1bmThnBP3Zj7tegglL8d3up/rN71FixYsXryYvn37Mn/+fFJSUgDYvHkzIkK3bt3Yt28fAwcO5JFHHuHQoUMAPPHEE8THx9OgQQNee+01atas6bd9wzCMghJoQOuLY/P0AE5AqQI882cerPkYBvvwFY4N1fdAYxGpgHNky1FgK9ASx4Lqr8AjAG4AvgzHYHgx+Qe0dGCTiLRV1bU47vwfABfkUv4lYJSIvJ1Xo6Hq5Zjt3fbbb79x5MgRj4/bnXfeyfjx4xk9ejSXXXYZZcqUIT4+nqSkJL744gumTZtG+fLleeihhyhbtiwNGzbkl19+oUqVKrzwwgt88MEHDBkyhMceeywoekMB0xo8QkmvaS18AnXbPyIidYFGqjrHNePNdb+XHwpiGOxNL2CDOq72CTjH2FQAvgG2AH91R42iqilunWtxNlVvFpH/iUhrVf0uH52xwEAR+Q1nBPYruQe0n3FGf0NwvC79oqrTgekATZo00ftu7puPhJJBfHw80dHRJCcnc+65556yaXnoUOd4vM2bN7Nx40aio6P57bffSE9Pp29fp39r1qzhxIkT9OnTh4oVK/LEE09QpkwZGjRoQPfu3XNsgi4svaGAaQ0eoaTXtBY+ga5yvB34EMg+DbE2p07t5YfvGWXz3PRY4HoRKYMT2GJ86sW5Aawyzl44cBaj/NX9rHY/f8UZjX3tVXeQ2372cwaRP5/huKIMAublUxbgH8BoAn8XGfJkH5554sQJxo8fz5133glAt27dWL9+PUePHiUzM5Ply5fTvHlzRITevXt7/rpbtmwZzZs3Ly75hmGUYgKdcrwHuARnRISqbnH3pP0pcjMM9qKzqu73SfsauANnP9zrwD6cwzX34a68FJHqwJVACxFRnNGkisgjrnNzbnqOi8g64CEgAuidj/6tbsDNzUkkpBk0aBDx8fHs37+fOnXq8PTTT5OWlsbrr78OQP/+/bnlllsA55iWBx98kHbt2iEi9OjRg549nTPMJk2axJAhQ3jggQc4//zzmT17drH1yTCM0kugAe0P95c9ACJSDsg1MJwm/gyD8+JrYDawS1X3unr24bznu8Etcz3wrqrekV1JRJYDl+MsbMmLqcByVT3gfcJxHjwHhMZKj9MkJsZ3wOwwcuRIv+mDBw9m8ODBOdLr1q3LV199VajaDMMwfAl0qmy5iDyG8y6sC47Jb67vjfxQwWfZ/kSvvPk4o6HYXOqegqoexBmNea9AXA3UABLd+9wMh28KoP2NqjonEC3Z5YH83s0ZhmEYQSbQEdpY4FZgA85036fAjEAfcrqGwW56vTzqRPjcj8NrFaOqRvup84pvmldeMn6MhlX1HeAdr2dkpw/3Kdc/t7YNwzCMoiE/t/2LVPVnVT0BvO1+DMMwDKPEkd+Uo2clo4iEvAGfiLT0mfpMEJFv8q9ZOvHn1Qjw6quvMnToUCIiInjkkUcAOHDgAJ07dyYsLIx7773XUzY1NZWoqCjPJzw8nAcesOPiDMMoevKbcvReFVE/mEIKAxHJwpkWzSYWZzVkeVV9VFU3AFEiEgXEqGqzbIstnH1nZYG/q+oin/bEzb9XVb8WkR1Ad1VN8nr2S8Cvqvp8EXS1UBg+fDj33nuvZ18ZQFxcHIsWLWLGjBl07drVs0z/nHPO4dlnn+WHH37ghx9+8JSvVKkSCQkntxi2adOG/v1tBtYwjKInv4CmuVyXVP6sxVYTYAmwyLc9EemGsxeuE+4GbOBpN68MzsrKywq9R0GkY8eOJCcnn5L25ptvMnbsWMqVc/5p1Kjh7M4499xzufzyy9m6dWuu7W3ZsoW9e/dyxRVXBE2zYRhGbuQX0CJF5DDOCKWCe417r6paOajqCoHTtNiqDBzMpSnvvBicjddPu/cdgWRV3ZmXlpLk5Zg8saff9M2bN7NixQo++OADatSowZQpU2jXrl1AbcbExDBgwAAC3O5gGIZRqOR3wOfp2FuVBApqsRUnzm/h+py6STq7vXOAWjibtVHV9SJyQkQiVTUR/y4nQMn1csx27vD1avz999/ZsGEDzz//PL/88gt9+vTh/fff9wSpn376iV27dvn1dct21S8Oz7dQ8ZoD0xpMQkmvaQ0CqlpqPkBaLukXAik4i2BeAh70yksGwt3rBu59mG97OC4mG3H8IgH+jjMFWQ7YDdTIT1/jxo21pLFjxw6NiIjw3Hfr1k3j4uI0Li5OVVXr16+ve/fu9eTPnj1b77nnnhztJCQkaKNGjYKuNzey9YYCpjV4hJJe0xo4wFoNIAacER6E6hgWJ3PSYuuDXMptA/bgWGn55q0GwoHz3aQYnNHc1cB6dV1LQp1rr72WL7/8EnCmH48fPx7Q+WUxMTEMGhSIXaZhGEZwCHRjdWkgX4st15/yYiDHuzD3kNCywAFwgp+IHAAm4oz6Qg5/Xo0jRoxgxIgRzJ07l2rVqjFnzhzPdGO9evU4fPgwx48fZ+HChSxZssRjNPzBBx/w6aefFmd3DMM4wyltAc33HdpnqjrWvZ4PvAzc56denLtE/yxgrKru8dOeAMPUOUg0mxicaUdfm62QIDevxvfee8/vcRG+KyK92b59eyEqMwzDOH1KVUDTwrfYynNRjKq+iDPqMwzDMIqZM+IdmmEYhlH6sYBmGIZhlApK1ZTjmUBSUhIDBgzw3G/fvp1nnnmGXbt28a9//Yuzzz6bBg0aMHv2bKpWrQrA+vXrueOOOzh8+DBlypRhzZo1nHPOOcXVBcMwjKBgI7QQo0mTJiQkJJCQkMC6deuoWLEi/fr1o0uXLvzwww+sX7+exo0bM2HCBAAyMzMZPHgw06ZNY+PGjcTHx3PWWTleJRqGYYQ8JTqgiUiWjzP+WBEZJyITfMpFicgmr/u/iIi6/ove5f5PRGJFZJuI/Cgin4pIYzcvQkS+FJHNIrJFRJ6QPDycRGS2j7ZkEdmTW/lgsGzZMho0aEDdunXp2rWrx3/x0ksv5ZdfnJ0JS5YsoVWrVkRGRgJQvXp1ypYNNQMYwzCM/CnpU44FNRseBKx0f37u1hOc5fVzVHWgmxYF1BSRFGAxcJeqLhGRijgnXN8NvO5PmKre4qWpDBAPvJtnZ/6kl6Ov/2JsbKzfzcyzZs3yTEtu3rwZEaFbt27s27ePgQMHeo6EMQzDKE1k2ziVSEQkTVXD/KR/hxN8vnHvtwPdVHWLG7i2AV2AFUB9VT0mIlcC41S1o5/2bgU6qepQr7QGQLyqXhiAzr8DrdXPydU+Xo5tnnyp4GektqxdxXOdkZHB9ddfz+zZsznvvPM86e+99x5JSUk888wziAjz5s1j4cKFTJs2jfLly/PQQw8xYsQI2rRpk+ez0tLSCAvL8dWXWEJJr2kNHqGk17QGTufOndepatv8ypX0EVpBzIYvA3a4Th7xQA/gI6AFsC6X50T45rn1w0SksqoezqUeInIJcBvQ2l++qk4HpgNcVL+hTt1Q8K88+eZoz/WiRYto3779KWePzZkzh40bN7Js2TIqVqwIOObD6enp9O3bF4A1a9Zw4sSJHJumffG3sbokE0p6TWvwCCW9prXwKekBLceUo0ss8LWIPEROp/tBbn52uSE4AS0vhNzPe8t1CCsiYcBc4FZV/V8+z6DCWWVJyuXYltPF1zvxs88+Y9KkSSxfvtwTzAC6devG888/z9GjRzn77LNZvnw5o0aNKhQNhmEYJYmSHtD8oqopIpLMSbPhDgAiUta97yMij+MEquoiUgnHKf/6XJrciHOmmQcRqY/jtp+ah5RXgcWquuxPdOe0OXr0KEuXLuWtt97ypN1777388ccfdOnSBXAWhkybNo1q1arx4IMP0q5dO0SEHj160LNn4QRVwzCMkkRIBjQXf2bDVwOJqupZ3Sgic4BrgfeAf4jI7ar6tpvXDqgI/BN4TESuVtUvRKQC8ArwfG4PF5HrgUjg0sLvWt5UrFiRAwcOnJKW10nSgwcPZvDgwcGWZRiGUayU6GX7uO/QvD4TvfLm47z7ivVKG0ROo+AFwE3umTr9gC7usv2NwDjgV1VNB/oCfxeRJGADsAZ4LQ9tz+EcJfOtj8YKBe+uYRiGUVBK9AjtdM2GVXW4n3KLcZbko6q/cuqJ1N7lNgDRp6GtSaBlDcMwjOBT0kdohmEYhhEQFtDyQURu8ZlSTBARv5utg0W9evVo2bIlUVFRtG176laMKVOmICLs37/fkxYfH09UVBQRERF06tSpKKUahmEUGyV6yrGguId1bvBKigXOAcqr6qNe5aKAGFVt5q6aTAVOAHuAoar6G85KybI4y/fLAI+r6iJ3/9vLQHn3M09VxwWrT3FxcYSHh5+SlpKSwtKlS7nooos8aYcOHeLuu+/ms88+46KLLmLv3r3BkmQYhlGiKJUBjYJbZnVW1f0i8g+cVY/PA4/juID87u47O98tOwe4UVUT3e0CRf5ObdSoUTz//POeTdMA77//Pv379/cEuRo1ahS1LMMwjGKhtAa0HKhqkogcEpH22ZZZOAtEuvkp/hVwP1ADZ9SW5raRln3t5u1207OAH/PTcLpejtnejSJC165dERHuuOMO/va3v7F48WJq167tMR3OZvPmzWRkZBAdHU1qaiojR45k6NCh/po3DMMoVZTWgFYQyyxveuFMWSbiTD/uEJFlwEeq+i+3zItAkmuv9RmO6fEx3/eHMk4AABeTSURBVIZ8vBx5smVmwJ2Ij48HYPLkyYSHh3Pw4EEefvhh0tPTmTZtGpMnTyY+Pp5jx46xatUqqlSpws6dO0lKSmLq1KkcP36ce+65BxHhwgvztaQ8hbS0NM/zQ4FQ0mtag0co6TWthU9pDWgFscz6//buPjqq6tzj+PcnWFBRDFJvEXpNsWopJhBeLtBLEWuRF63Kwlqx9Nar9N7awm1BY2VpXXCtVVEp2riKrYpKlVpprYpKETW+9RbBGhC0CJhU0dqCgpAUioHn/nH2hMlkJm/MZDKT57PWLM7Ze59zntlJZnNe5tkAz4b7b2uBq81sn6RxwFDgdOAnkgab2Wwz+19J9wNnABcSfQdudOIBDyaXY3zuxpg1a9awc+dOPvjgA6ZNmwbAtm3bmD59Oi+//DLDhg1jwIABjB8/HoBHH32Url27tjgPW67kbovJpXg91szJpXg91vTL1wEtqVQps+KcZmbbErYx4GWiL1A/BSwk+kI2ZrYZ+JmkXwBbJR1jZh+QQmtyOdbU1LB//36OPPJIampqWL58Oddcc029hz0KCwtZvXo1PXv25JxzzmHatGnU1tayd+9eVq5c6bkbnXMdQoca0IJkKbOSknQc8Ckz+1MoGgj8JdSdCTwRBrwTgX3AjnQH+7e//Y2JEycC0ezTF154IePGjUvZvl+/fowbN47i4mIOOeQQpk6dyimnnJLusJxzrt3J1wEt8R7aMjO7Miw/RPS4/fRm7OdQ4OYwsO0BtgLfDnXfILoE+Q+gFvh6eDgkrfr27cuaNWsabVNVVVVvvbS0lNLS0nSH4pxz7VpeDmgtTZkVyguTlP0F+FKK/VxwECE655xLM88U4pxzLi/4gOaccy4v+IDWju3bt4+SkhLOOuuseuXTp0+nW7dudesLFiyoy/U4cuRIXn+9ye94O+dc3smbAU3SvoQEwldKmi3p+oR2AyW9EZa7SfpZmB/tVUmvSPpWqCuUtDvs63VJCyQdEur6S3pG0puSNkr6oSSl+z3deuut9OvXr17Z6tWr2bGj/sOUF154Ia+99hoVFRVcccUVzJw5M92hOOdcu5c3Axrhy9RxrxuIHtH/WkK7+PyNdwLbgRPNrAQYB/SIa7s5fEG7GPg8cG6YwPNR4AYzO4lo1uovAN9J55vZsmULjz/+OFOnTq0r27dvH6WlpcydW38i7aOOOqpuuaamhgyMrc451+7l5VOOMY3lb5R0AvBvRLNZ7w/ttwI3JtlPraQ/AJ8lygrykpktD3X/kDQNKAcanVamubkcq244k+9///vMnTuXXbt21ZWXlZVx9tln06tXrwbb3H777cybN4+9e/fyzDPPNHkM55zLN4q+F5z7kkwZc72ZPSipFDjOzGaE/I0/NbOhks4G/tPMJqbYXyGw1MxOkXQ48BxwDTAG+IuZ3ZrQfjtwvJntTCiPz+U4+Jr5v2jyvVS//Tp//OMfmTFjBhUVFTz44INcdtllzJkzh/nz59OpUyfGjx/Pk08+2WDbFStWsGrVKmbNmpVkz81XXV1d7z5de5dL8XqsmZNL8XqszXfaaae9YmZDmmqXTwNatZk16HFJnwb+ABwPzAPeNrN5iQOapKuArwLHmtlxYUB7A9hANBfaI2Y2W9JPgEozuy3hONuBfzWzXaTwr30/a4ecf2uq6jqT9SKLFi2ic+fO7Nmzh507d9KlSxe6dOlC165dAXj77bfp27cvmzZtqrft/v37KSgo4KOPPmryOI3JldxtMbkUr8eaObkUr8fafJKaNaDl9SVHaDR/4+vAAEmHmNl+M7sOuE5SddzmsXto8dYDo+ILJPUFqhsbzKAluRzP5Prro2dZysvLufnmm1m6dGm9Ft26dasbzDZu3MiJJ54IwOOPP1637JxzHUneD2hBg/yNZrZJ0mrgR5J+GDLrdyWaobox9xNN/vllM1sRHhK5DZjbxHYZU1ZWxooVKzj00EMpKCjg3nvvzVYozjmXNfk0oLUmf+NU4CZgk6QPgd3ADxo7iJntlnQO8FNJtwOdgEVAWRreQwOjR49OeqpfXX3gRPLWW5u+jOmcc/kubwa0VuZv3An8d4ptqoCkaerN7DWSzH3mnHMue/Lpe2jOOec6MB/QnHPO5QUf0NqBd955h9NOO41+/frRv3//untis2fPpnfv3gwcOJCBAwfyxBNPAPDUU08xePBgioqKGDx4sH+R2jnnyKN7aK0V+/5a+N5ZJfAjM/thqOsJ/BW4w8ymSZoNfItoos+Y0UQzWV9uZvWzCDdT586dueWWWxg0aBC7du1i8ODBjBkzBoAZM2Zw+eWX12vfs2dPHnvsMY477jjWrVvH2LFjeffdd1tzaOecyxsdfkBL8BZwFvDDsP5Vou+dxfuJmd0cX3CwuRN79epVl87qyCOPpF+/fo0OUCUlJXXL/fv3Z8+ePfzzn/+kS5cuBxWHc87lMh/Q6tsNvCFpiJmtJkps/GvguLTsPEUux6q4L1tXVVXx6quvMmzYMF566SXKysq47777GDJkCLfccgsFBQX1tv3Nb35DSUmJD2bOuQ7P76E19CvgAkl9gH3Aewn1M+KmqHk2nQeurq5m0qRJzJ8/n6OOOopLL72UzZs3U1FRQa9evbjsssvqtV+/fj0/+MEPuOOOO9IZhnPO5aS8yeXYWgn30JYCg4BVwC+Bj4C9wJC4e2jVSS45jibFPbTmJCcu6t2d2tpaZs2axdChQzn//PMbtHn//feZNWsWCxcuBGDr1q3MnDmTK664gqKiola//1SynYy0pXIpXo81c3IpXo+1+ZqbnBgz69AvogEKoBBYF5bvBt4HjgEuAspC+WyigStxH6OJMvM3eqyTTjrJktm/f7994xvfsO9973v1yt9777265Xnz5tnXvvY1MzPbvn27FRcX25IlS5LuLx2effbZjO07E3IpXo81c3IpXo+1+YDV1ozPc7+HltwtwHNm9kFbTJb50ksvsWjRIoqKihg4MMqF/OMf/5jFixdTUVGBJAoLC+suLZaVlbFp0yauvfZarr32WgCWL1/Osccem/FYnXOuvfIBLQkzW0/DpxtjZkiaErd+7sEeb+TIkbEzvXomTJiQtP3VV1/N1VdffbCHdc65vNLhBzQLc6hZityNZnYPcE9Ynk102TFRFdGM1c4557LEn3J0zjmXF3xAc845lxd8QMuyiy++mGOPPZZTTjlwtTNVDkeAtWvXMmLECPr3709RURF79uzJRtjOOdfu+ICWZRdddBHLli1rUD5jxgwqKiqoqKioeziktraWKVOmsGDBAtavX095eTmHHtpgmjfnnOuQsjqgSdoXl3WjQtKVkmZLuj6h3UBJb4TlqpA0OH77dZIek3S0pKK4/X0oqTIsr0gRQ6Ekk3RtXFlPSR9Lysgs1PFGjRpFjx49mtV2+fLlFBcXM2DAAACOOeYYOnVKOa+pc851KNk+Q9ttZgPjXjcAi4lyKMa7AHigke1PAT4Evmtmr8X2BzwKlIb1LzcSRywpcUyypMQHLZbLMVk+x0RlZWUUFxdz8cUXs337dgDefPNNJDF27FgGDRrE3Llz0x2ic87lrGwPaA2Y2QZgh6RhccXnE+VYbMz/Ab1bedi6pMRhPZaUGABJX5G0UtKrklZI+pdQfpuka8LyWEnPSzroPk2Vw7G2tpYXX3yR+++/nxdffJGHH36Yp59++mAP55xzeSHb30M7TFJF3Pr1ZvYg0VnaBcBKScOBD8xsY6qdSOoEnA7cdRCxxJISv8+BpMSxLPsvAsPNzCRNBa4ALgOuBFZJegG4DZhgZvsTYovP5cg1RbUAlJeX17V5//33qampqVcWU1RUxAMPPEB5eTk7d+7k5JNPZt26dQD069ePhx56KCOXHaurq5PG017lUrwea+bkUrweawY0Jz9Wpl6EPIpJyj8NvEN0BjkfmBlXVwX0DMv7gApgB/A00ClhP/cA5zURQyGwDvgEsAYoJRqALuJADsciYDnwGrABWBa3/ReAWmB6U+83VS7HyspK69+/f916qhyOH374oZWUlFhNTY19/PHHdvrpp9vSpUuT7vNgZTt3W0vlUrwea+bkUrwea/ORy7kczewdSVXAqcAkYESKprvNbKCk7kSZ8r9LdKbUmmPulfQK0ZlXf+ArcdU/BeaZ2aMhs/7suLoi4ANaOWfa5MmTKS8vZ9u2bfTp04c5c+ZQXl6eNIdjQUEBM2fOZOjQoUhiwoQJnHnmmU0cwTnnOoZ2OaAFi4GfAJvNbEtjDc3sI0n/Azwi6Wdm9nErj5kqKXF3IDaF9DdjhZKOJxoAS4AnJP3OzFa25ICLFy9uUHbJJZekbD9lyhSmTJmSst455zqqbD8UcljCY/s3xNU9RHSm1NTDIACY2atElwwvaG0wZrbezO5NUjUbeCjcK9sGoGjEu4toOpn3gEuAOyV1be3xnXPOtV5Wz9DMLOXTDGa2FWjwrWEzK4xb7pZQ95WE9YuaEUMVTSclfgR4JMnmX45r/wrR5UfnnHNZkO0zNOeccy4t2vM9tLSSVAQsSij+p5kNS9beOedcbukwZ2gWl0Ek7pXVwSxZYuLS0lI+97nPUVxczMSJE9mxYwcAVVVVHHbYYXUJi7/97W9nK2znnGuX8m5Aa2V+yG6S7pC0WdL6kPFjWIr9FUoaHfI/fiVuf0vDI/3Nliwx8ZgxY1i3bh1r167lpJNO4vrrD4R9wgkn1CUsXrBgQYv7xjnn8lk+XnLcbVEexzqSTgaeBGbFFcfnh7wTqARONLP9kvoC/RrZXyGwBbgKeKy1gY4aNYqqqqp6ZWeccUbd8vDhw1myZElrd++ccx1K3p2hJWON5IeUdAIwDLjaQtoqM3vLzJrKILwG+EjSmObG0ZLkxAB3330348ePr1uvrKykpKSEU089lRdeeKG5h3XOuQ4hH8/QWpQfUtLZQIWZ7WvG/irNbGJc3Y/C66lUwTSVyzFVHsdf/vKX7Nixg969e1NeXs7evXt54IEH6N69Oxs2bGDSpEksXLiQI444ohld0nI5k7styKV4PdbMyaV4PdYMaE5+rFx60cL8kMDZwMMt2R8wGlgalp8DvkiUemt0Y7Ely+WYmMfRzOyee+6x4cOHW01NTYP2MaeeeqqtWrUqZf3BynbutpbKpXg91szJpXg91uYjl3M5ZoKlzg+5Hhgg6RBLyJTfTNcR3UurTUecy5Yt48Ybb+S5557j8MMPryvfunUrPXr0oFOnTrz11lts3LiRvn37puOQzjmXFzrEPbQ4DfJDmtlmYDUwJ6SzQtKJks5pzg7NbDlQAAxoaTCTJ09mxIgRbNiwgT59+nDXXXcxbdo0du3axZgxY+o9nv/888/XzVZ93nnnsWDBgmbPdO2ccx1BPp6hJd5DW2ZmV4blh4BbgekJ20wlSky8SdI/iLLnl7bgmNeRPDVWo1qSmHjSpElMmjSppYdwzrkOI+8GNGtdfsidwLdSbNMtSVk5UB63/iigxHbOOefaTke75Oiccy5P+YDmnHMuL/iA5pxzLi/4gOaccy4v+IDmnHMuL/iA5pxzLi8oyiri2oKkXcCGbMfRTD2BbdkOogVyKV6PNXNyKV6PtfmON7NPNtUo776H1s5tMLMh2Q6iOSStzpVYIbfi9VgzJ5fi9VjTzy85Ouecyws+oDnnnMsLPqC1rZ9nO4AWyKVYIbfi9VgzJ5fi9VjTzB8Kcc45lxf8DM0551xe8AHNOedcXvABrY1IGidpg6RNkq5seouMxPBpSc9KekPSeknfC+U9JD0laWP4tyCUS9JtIea1kgbF7eubof1GSd/MYMydJL0qaWlY/4ykleG4D0r6RCjvEtY3hfrCuH3MCuUbJI3NUJxHS1oi6c+hf0e0836dEX4H1klaLKlre+lbSXdL+rukdXFlaetLSYMlvRa2uS02sW8aY70p/B6slfSwpKPj6pL2V6rPh1Q/k3TGG1d3uSST1DOsZ7VvW8XM/JXhF9AJ2Az0BT4BrAE+n4U4egGDwvKRwJvA54G5wJWh/ErgxrA8AXiSaK634cDKUN4DeCv8WxCWCzIU80zgAWBpWP81cEFYXgBcGpa/AywIyxcAD4blz4f+7gJ8JvwcOmUgznuBqWH5E8DR7bVfgd5AJXBYXJ9e1F76FhgFDALWxZWlrS+Bl4ERYZsngfFpjvUMoHNYvjEu1qT9RSOfD6l+JumMN5R/Gvg98BegZ3vo21a9v7Y8WEd9hR/w7+PWZwGz2kFcjwBjiLKX9AplvYi+AA5wBzA5rv2GUD8ZuCOuvF67NMbXB3ga+BKwNPyRbIv7sKjr1/DHOCIsdw7tlNjX8e3SGOdRRAOEEsrba7/2Bt4JH0idQ9+ObU99CxRSf5BIS1+Guj/Hlddrl45YE+omAveH5aT9RYrPh8Z+39MdL7AEGABUcWBAy3rftvTllxzbRuwDJGZLKMuacNmoBFgJ/IuZ/RUg/HtsaJYq7rZ6P/OBK4D9Yf0YYIeZ1SY5bl1Mof6j0L4tYu0LbAUWKro8eqekI2in/Wpm7wI3A28DfyXqq1don30bk66+7B2W2yJmgIuJzlRoIqZk5Y39vqeNpLOBd81sTUJVe+/bBnxAaxvJriNn7fsSkroBvwG+b2Y7G2uapMwaKU8bSWcBfzezV5oRT2N1bdH3nYku4/zMzEqAGqLLYqlkM1bC/adziC57HQccAYxv5NhZjbcJLY2tzWKWdBVQC9wfK2phTG3xd3Y4cBVwTbLqFsaV9d8HH9Daxhaia9QxfYD3shGIpEOJBrP7zey3ofhvknqF+l7A30N5qrjb4v38O3C2pCrgV0SXHecDR0uK5SCNP25dTKG+O/BhG8W6BdhiZivD+hKiAa499ivAl4FKM9tqZh8DvwW+QPvs25h09eWWsJzRmMODEmcBX7dw/a0VsW4j9c8kXU4g+o/NmvC31gf4k6RPtSLeNunbRrXl9c2O+iL6H/xbRL84sZu+/bMQh4D7gPkJ5TdR/4b73LB8JvVvCr8cynsQ3TMqCK9KoEcG4x7NgYdCHqL+TfLvhOXvUv/BhV+H5f7UvxH/Fpl5KOQF4OSwPDv0abvsV2AYsB44PMRwLzC9PfUtDe+hpa0vgVWhbezBhQlpjnUc8DrwyYR2SfuLRj4fUv1M0hlvQl0VB+6hZb1vW/ze2vJgHflF9MTQm0RPM12VpRhGEl0CWAtUhNcEomv1TwMbw7+xX04Bt4eYXwOGxO3rYmBTeP1nhuMezYEBrS/Rk1Sbwh97l1DeNaxvCvV947a/KryHDWToqStgILA69O3vwh96u+1XYA7wZ2AdsCh8yLaLvgUWE93b+5jof/2XpLMvgSHhfW8Gykh4mCcNsW4iuscU+xtb0FR/keLzIdXPJJ3xJtRXcWBAy2rftublqa+cc87lBb+H5pxzLi/4gOaccy4v+IDmnHMuL/iA5pxzLi/4gOaccy4vdG66iXOuvZO0j+jR6phzzawqS+E4lxX+2L5zeUBStZl1a8PjdbYDOQadaxf8kqNzHYCkXpKel1QR5kD7YigfJ+lPktZIejqU9ZD0uzAH1h8lFYfy2ZJ+Lmk5cJ+iuepukrQqtP3vLL5F5/ySo3N54jBJFWG50swmJtRfSDT1yHWSOgGHS/ok8AtglJlVSuoR2s4BXjWzcyV9iShd2sBQNxgYaWa7Jf0X8JGZDZXUBXhJ0nIzq8zkG3UuFR/QnMsPu81sYCP1q4C7Q3Lq35lZhaTRwPOxAcjMPgxtRwKTQtkzko6R1D3UPWpmu8PyGUCxpPPCenfgRKLcfs61OR/QnOsAzOx5SaOIEs4uknQTsIPk03s0Ng1ITUK76Wb2+7QG61wr+T005zoASccTzS/3C+Auoult/g84VdJnQpvYJcfnga+HstHANks+b97vgUvDWR+STgoTmzqXFX6G5lzHMBoolfQxUA38h5ltDffBfivpEKI5xsYQTX+zUNJa4B/AN1Ps806iqUj+JElEs3afm8k34Vxj/LF955xzecEvOTrnnMsLPqA555zLCz6gOeecyws+oDnnnMsLPqA555zLCz6gOeecyws+oDnnnMsL/w/6kYJGvDyqtQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "xgboost.plot_importance(model_train)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "shap.summary_plot(shap_values, train)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([352891066263282, 352891066262722, 358272088699072])"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.IMEI.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.932720370829546"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data[\"tp\"] == 42].EVIND.corr(data[data[\"tp\"] == 42].EVSMA_MAX)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
